|
Posted by Steve London on 03/08/07 21:43
I'm sure this has been brought up many times, but I will ask anyway.
Let's say I have 2 tables related:
Owner:
---------
o_id
o_name
Dog:
---------
d_id
d_name
o_id - for Owner table.
If the data is laid out as
o_id o_name
1 John
d_id d_name o_id
1 Skippy 1
2 Fido 1
How can I make a query that will produce the following results:
o_id o_name owned dog names
1 John Skippy, Fido
I think it has something to do with unions but I can't seem to get it. I'm
using SQL Server Compact Edition.
Navigation:
[Reply to this message]
|