Hi All,

Can any one help in building a SQL query to get the below output;

ID Name Checks Re-Orders
------------------------------
1 AB 150 5
250 10
350
2 CD 200 20
15
3 EF 100 25
200 100
4 GH 300
5 IJ 50

My data is stored in 3 tables like this;

Table A Table B Table C

ID Name ID Checks ID
Re-Orders
---------- ------------- ------------
1 AB 1 150 1
5
2 CD 1 250 1
10
3 EF 1 350 2
20
4 GH 2 200 2
15
5 IJ 3 100 3
25
3 200 3
100
4 300 5
50

Thanks in advanced.

Mohan.

Oracle LazyDBA home page