Which type of join ?

[Anonymous]

Dear all,

I've two tables like these:

Table1

OrderID     Customer

1               A

2               B

3               C

4               D

Table2

OrderID     OrderDetail     Product

1               1                    zz    

2               1                    yy

4               1                    xx    

I need to extract only the ORDERID without any entry into Table2. In this case the OrderID 3

How can I solve it ?

Help please

Thanks in advance

[swuehl · Accepted solution]

If you have already loaded your two tables into QV, you should be able to do it like this (untested):

TMP:

LOAD

OrderID as OrderIDTable2

resident Table2;

MissingIDTable:

LOAD

OrderID as MissingOrderID

resident Table1 where not exists(OrderIDTable2, OrderID);

Hope this helps,

Stefan

[Anonymous]

THANKS !! IT WORKS