|
|
Posted by jeffvh on 03/21/06 23:38
I have 2 tables related as:
T1.KEY, T1.FIELD1, T1.FIELD2
T2.KEY, T2.FIELDA, T2.FIELDB
T2.KEY, T2.FIELDA, T2.FIELDB
T1.KEY = T2.KEY
I want to return a SELECT as:
T1.FIELD1, T1.FIELD2, T2.FIELDA, T2.FIELDB, T2.FIELDA, T2.FIELDA
The second table, in some cases but not all, has multiple rows for each
row in T1. I want to return a single row with all values for T2.FEILDA
and B.
--
jeffvh
------------------------------------------------------------------------
jeffvh's Profile: http://www.dbtalk.net/m47
View this thread: http://www.dbtalk.net/t293766
Navigation:
[Reply to this message]
|