Advertisements
Offline
trezkyler
Posts: 1
Joined: Wed Jul 03, 2013 12:06 am
ex.

table1
ID column1
Name column2

table2
ID column1
Fruit column2

RECORD:
table1
1 Jeff

table2
1 Apple
2 Grapes

Query Result: (I need the query of this result)
____________________
Jeff | Apple, Grapes
-------------------------

Query must not result like this
SELECT * FROM table1 INNER JOIN table2 ON table1.ID = table2.ID
WHERE table1.ID = '1'