Lookup form, OuterJoin и фильтр

[AndyD]

2 MironovI

А вот так?

SELECT *
FROM {oj INVENTTABLE A LEFT OUTER JOIN CUSTVENDEXTERNALITEM B ON
((B.DATAAREAID='dem') AND ((B.EXTERNALITEMID='121') AND (A.ITEMID=B.ITEMID)))}
WHERE (A.DATAAREAID='dem')