How to join two tables by 5 columns? Sql

Question

I have two tables called customers and wantslist. I want to join the columns customername, customeraddress , creditlimit , bytitle and byauthor.

How can I write a query that can show those column together in a table?

The first table is customers. It has the columns customeraddress , customername and creditlimit.

The second table is wantslist. It has the columns bytitle and byauthor.

How can I write a query that can join those 5 columns into 1 table?

Have a look at [ http://stackoverflow.com/questions/3536283/how-to-join-two-tables-mysql ] or [ http://www.w3schools.com/sql/sql_join.asp ] — Nishant Nair, Jan 24 '17 at 05:24
Possible duplicate of [How to join two tables mysql?](http://stackoverflow.com/questions/3536283/how-to-join-two-tables-mysql) — Ravi Matani, Jan 24 '17 at 05:25
can you provide more information about the two tables such as the columns of each — Jesse Hockenbury, Jan 24 '17 at 05:30
`SELECT c.*, w.* FROM customers c CROSS JOIN wantslist w` try this code — Ehsan Ilahi, Jan 24 '17 at 05:35
See http://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query and update again — Strawberry, Jan 24 '17 at 08:26

score 1 · Answer 1 · edited Jan 24 '17 at 07:00

1

Without knowing your specific strucutre you would use a SQL query similar to...

SELECT c.customername, c.customeraddress, c.creditlimit, w.bytitle, w. byauthor
FROM customers as c
JOIN wantslist as w on c.customerid = w.customerid

edited Jan 24 '17 at 07:00

Deepak Mahakale

22,834
10
68
88

answered Jan 24 '17 at 05:36

Jesse Hockenbury

114
5

Take a look at your w, where is it came from – Vijunav Vastivch Jan 24 '17 at 05:37
Why would you add customerid? – Yuuki Sama Jan 24 '17 at 05:44
there needs to be a customerid column in both tables. in the customer table it is used as a unique identifier and in the wantslist table it is used as a foriegn key which ties the two tables together. – Jesse Hockenbury Jan 24 '17 at 05:51

score 0 · Answer 2 · edited Jan 24 '17 at 07:00

0

SELECT customers.customername, customers.customeraddress, customer.creditlimit, wantslist.bytitle, wantslist.byauthor
FROM wantslist
INNER JOIN customers
ON *{your matching condition}*;

edited Jan 24 '17 at 07:00

Deepak Mahakale

22,834
10
68
88

answered Jan 24 '17 at 05:38

Anan Srivastava

112
1
9

What's matching conditions? – Yuuki Sama Jan 24 '17 at 05:43
Something you can set an equal to on. For example { .. ON customers. abc = wantslist.abc.} You must be having a common column in both tables. Use that column in place of abc and you'll be fine. – Anan Srivastava Jan 24 '17 at 05:46

How to join two tables by 5 columns? Sql

2 Answers2