Subquery support

JohnH · Post by **JohnH** » Thu 08 Dec 2005 19:28

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?

Challenger · Post by **Challenger** » Fri 09 Dec 2005 12:55

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.