Hi,

I don't want to alter any table, I want this done by a sql select statement only? Plus this would not work as only want it to appear as Yes where every product is matched on the order line?

Thanks