SQL select statement with a group clause?

Asked Jun 27 '17 at 14:17

Active Jun 27 '17 at 14:45

Viewed 48 times

I am not sure how to go about this select statement.

table1
----------
t1id |  t1field1  |  t1field2

table2
----------
t2id |  t1id  |  t2field1  |  

outputTable3
----------
t1id  |  t2field1(row1)  |t2field1(row2) | t2field1 (row...)

My current results ouput (not what I want)

outputTable3
----------
t1id  |  t2field1(row1)
t1id  |  t2field1(row2)
t1id  |  t2field1(row...)

edited Jun 27 '17 at 14:45

asked Jun 27 '17 at 14:17

ebates

1

Search for `Dynamic Pivot` in Sql Server. – Pரதீப் Jun 27 '17 at 14:18
1

This has been asked and answered hundreds and hundreds of times. – Sean Lange Jun 27 '17 at 14:32

SQL select statement with a group clause?

0 Answers0