Code:
SELECT id, name, source
FROM traders
WHERE traders.id in (SELECT SI.supplierid FROM supplieraccountinfo SI )
/
Well yes this works but it doesn't help.
The example I have given is a very much simplified version of one of our actual statements.
It needs to use FULL ANSI SQL syntax.