outer join 2 fields vfp9
Posted on 2010-09-08
I may be missing something here but....
I have 2 vfp tables; orders.dbf and leads.dbf
orders is a table with all sales orders for glass windows in it, including fields 'order_ no' and 'line'
leads is a table with all orders with lead designs, including fields 'order_ no' and 'line'
Most orders have more than one line
Not all orders have lead designs.
So I want to run a query that lists ALL orders, and the lead designs for those orders that have them.
This will require an OUTER JOIN on 'order_no' AND line.
But vfp returns an error; it cannot seem to define the second join.
Am I breaching SQL rules or am I missing something?
Neither table has a key field - they are free tables.