I have 2 tables, one contains orders one contains items,
in items I have a key SUPPLIER in orders I have key ITEMNUMBER and CUSTOMERID
so every record in items has the keys ITEMNUMBER and SUPPLIER active
and every record in orders has the keys ITEMNUMBER and CUSTOMERID active
my needed query is to get in one call as sample
return all records from orders based on key 'SUPPLIER= 'SONY' in items,
and only for CUSTOMERID= 'JACK'
How to get this from the tables in one call?
Start Free Trial
