SELECT Query ( 1 row that contains 2 record from Inner Join)

General discussion on technical and managerial topics
no avatar
trezkyler
 
Posts: 1
Joined: Wed Jul 03, 2013 12:06 am

SELECT Query ( 1 row that contains 2 record from Inner Join)

by trezkyler » Wed Jul 03, 2013 1:09 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'

Return to General Discussion