tspot (11/5/2008)

---

[font="Courier New"]Hi,

I have these tables :

TABLE1

ID NAME PARENTID

=== ========= ========

1 SALES -1

2 MIS -1

3 LANG 1

4 RAMA 3

5 ANDRE 2

6 ROY 5

TABLE2

DATE ID QTY

===== === =====

01/01 3 1

01/01 5 2

02/01 6 6

How to make a query for below result:

DATE DEPT QTY

--------------------

01/01 SALES 1

01/01 MIS 2

02/01 MIS 6

[/font]