I have data in 2 tables (master-detail concept) I want to present results in the query with all details in one row. I'm working in SQL 2005, I do not know number of det per master... Please help...
Data:
Master Table: Details Table:
ID FF1 ID FFd1 FFd2
1 User1 1 DetB DetA
2 User2 1 DetC DetH
2 DetA DetC
2 DetD DetF
2 DetG DetH
Expected result:
1 User1 DetB DetA DetC DetH
2 User2 DetA DetC DetD DetF DetG DetH
Note - thanks to CK9663 for answer re CSV file - it works OK..
Data:
Master Table: Details Table:
ID FF1 ID FFd1 FFd2
1 User1 1 DetB DetA
2 User2 1 DetC DetH
2 DetA DetC
2 DetD DetF
2 DetG DetH
Expected result:
1 User1 DetB DetA DetC DetH
2 User2 DetA DetC DetD DetF DetG DetH
Note - thanks to CK9663 for answer re CSV file - it works OK..
Comment