select distinct fid,(Select resname from resttable where rid=maintable.rid) as resname,price,rid from maintable output is 56 Restaurant A 56 Restaurant B 56 Restaurant C 56 Restaurant D 63 Restaurant A 63 Restaurant B 63 Restaurant C 63 Restaurant D 65 Restaurant B but i want 56 Restaurant A,Restaurant B,Restaurant C,Restaurant D 63 Restaurant A,Restaurant B,Restaurant C,Restaurant D
|Query Peformance + mulitple query plans||9||47|
|VB6 ListBox Question||4||30|
|MS SQL Inner Join - Multiple Join Parameters||2||18|
|T-SQL: What won't it just collapse? It would be the logical thing to do!||20||45|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!