SQL-Server. Select data from 2 tables

Question

I'm using SQL-server. I have 2 tables: Items (Id, OwnerId, ItemName) and Owners (Id, OwnerName)

It should select something like (connect data from 2 tables):

OwnerName | Items.Id | ItemName

I've tried:

SELECT OwnerName, Items.Id, ItemName
FROM Items, Owners

But It not working, have you ideas?

You probably need third table containing ids of both tables at least as relationship seem many-to- many — Adil, Mar 13 '15 at 12:13

score 0 · Accepted Answer · answered Mar 13 '15 at 12:12

0

You should JOIN tables.

SELECT o.OwnerName, i.Id, i.ItemName
FROM Items AS i
JOIN Owners AS o 
ON o.Id = i.OwnerId

answered Mar 13 '15 at 12:12

Or it could be: on o.Id = I.Id depending on your table structure – David B Mar 13 '15 at 12:16
I think It's good. `Id` from `Owners` table and `OwnerId` from `Items` table. Look at tables structure in question. – Stanislovas Kalašnikovas Mar 13 '15 at 12:20

1 Answers1