Devart Forums

I cannot get a subquery to work. I am trying to compare two tables and show the result in a grid. The intent is to get a list of parts that are in on table and not in another.

The sql is:

select a.part_25_no from a
where a.part_25_no not in
(select b.part_25_no from b)


This result in a list all the parts in table a not just the ones that don't exist in table b. Is ODAC supposed to support this?

Please try to execute your sql statement in SQL *Plus. If the result will
differ from the result you get using ODAC please send complete sample
to demonstrate it and include script to create server objects to ODAC
support address.