Combining column data from 2 separate SQL tables

Question

I have data in columns from 2 separate tables I'm looking to match up and analyze the output, but I'm a complete noob so I'm not sure how to write it. I've searched the results here but I guess I'm not understanding the answers

So If you don't mind helping, here's what I can do so far. The ItemID is the same for each item

SELECT ItemID, Title FROM Listings 
SELECT ItemID, SKU FROM Inventory

I tried plugging in UNION between the statement but I get error;

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation.

Thanks in advance

Possible duplicate of [SQL join: where clause vs. on clause](http://stackoverflow.com/questions/354070/sql-join-where-clause-vs-on-clause) — a coder, Apr 04 '17 at 20:15

score 2 · Accepted Answer · answered Apr 04 '17 at 20:03

2

You need to use join, like this:

SELECT a.ItemID, a.Title, b.ItemID, b.SKU
FROM Listings as a inner join Inventory as b on (a.ItemID = b.ItemID)

answered Apr 04 '17 at 20:03

Iłya Bursov

23,342
4
33
57

That is awesome! Worked like a charm. What is the significance of the a. b. how does SQL use them. – Chuck Apr 04 '17 at 20:09
And what if I wanted to use a LIKE statement to only match SKU's that start with '%STK%' in the above answer – Chuck Apr 04 '17 at 20:13
@Chuck then just add `where b.SKU like...` – Iłya Bursov Apr 04 '17 at 20:14

Tre · Answer 2 · 2017-04-04T20:12:56.780

1

You want an inner join between the two tables. Try something like

SELECT Listings.ItemID, Listings.Title, Inventory.ItemID, Inventory.SKU
FROM Listings
INNER JOIN Inventory ON Listings.itemId = Inventory.itemId;

edited Apr 04 '17 at 20:12

answered Apr 04 '17 at 20:07

Tre

34
3

Combining column data from 2 separate SQL tables

2 Answers2