Q:

Combining column data from 2 separate SQL tables

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

A:

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)

