Who's good at SQL? Your chance to shine.

[revolution saint]

I need to retrieve some data from a three linked tables that includes null values but also do some counting stuff. It's an oracle database. It should be nice and easy for some of you.

[Thedelldays]

ha...has dabbled (lightly) with SQL and sharepoint

 

but cant help you with that

[revolution saint]

ha...has dabbled (lightly) with SQL and sharepoint

 

but cant help you with that

 

NO EXCUSES FFS! ha ha thanks though.

[stevegrant]

Will probably need a little bit more info, to be fair!

 

Something along the lines of:

 

SELECT t1.col_1, t1.col_2, SUM(t2.col_3)

FROM tab_1 t1, tab_2 t2, tab_3 t3

WHERE t1.col_1 = t2.col_1

AND t2.col_1 = t3.col_1 (+)

ORDER BY t1.col_1 NULLS LAST;

 

The (+) command allows null results to be returned in the table join between t2 and t3 in that example.

[revolution saint]

Will probably need a little bit more info, to be fair!

 

Something along the lines of:

 

SELECT t1.col_1, t1.col_2, SUM(t2.col_3)

FROM tab_1 t1, tab_2 t2, tab_3 t3

WHERE t1.col_1 = t2.col_1

AND t2.col_1 = t3.col_1 (+)

ORDER BY t1.col_1 NULLS LAST;

 

The (+) command allows null results to be returned in the table join between t2 and t3 in that example.

 

Cheers, you have a PM Steve.