Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
THANKS !! IT WORKS