COMPLEX LEFT OUTER JOIN??

[stuartgmilton]

Hey Guys,

I have 2 tables which I want to group on Date and ResourceDisciplineID.

I have gotten this far but get stuck adding the 2nd join? Anyone able to help?

select TFU.*,
SI.*
from #TimeFrameUnion TFU
LEFT JOIN
#ScheduledInfo SI on
TFU.resourcedisciplineid = SI.resourcedisciplineid

 

[vbkris]

sorry i dont get your doubt. why do you want to group by (you dont use any aggregate functions)? do you mean order by???

select TFU.*,
SI.*
from #TimeFrameUnion TFU
LEFT JOIN
#ScheduledInfo SI on
TFU.resourcedisciplineid = SI.resourcedisciplineid
Order by ColumnNames

Known is handfull, Unknown is worldfull

 

[stuartgmilton]

I'm sorry what a chump!!

I meant Join!!

 

[gmmastros]

[tt][blue]
select TFU.*,
SI.*
from #TimeFrameUnion TFU
LEFT JOIN
#ScheduledInfo SI on
TFU.resourcedisciplineid = SI.resourcedisciplineid
[!]and TFU.DateColumn = SI.DateColumn[/!]
[/blue][/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[stuartgmilton]

Oh My God!! I'm so thick!

Thanks George.

Why is it that you stare at something for ages and can't see the obvious!