Re: join with criteria

???

What about the classic way: joining the tables table_a.primaryKey <--> table_b.foreignKey and using a WHERE Clause e.g.:

...

WHERE <joining condition like above>
AND order.status = 'A'
AND orderline.supplier = 'XXX'
...
Received on Thu Feb 07 2002 - 01:03:46 CST