Hi, Try the following statement instead:
Select *
from orderdetails
left semi join (
select orderid
from orders
left semi join sites on
orders.siteid = sites.siteid
) orders on
orderdetails.orderid = orders.orderid;
Matt
On Aug 3, 2012, at 6:17 PM, "kumar avijit" <[email protected]>
wrote:
> select * from orderdetails left semi join ( orders left semi join
> sites on (sites.siteid = orders.siteid) ) on
> (orderdetails.orderid=orders.orderid);
