thanks for you quick response, the following script works in Mysql 4.1.15 but not Mysql 4.0.18 , as I can not update the Mysql, is there any way that I can make this query work in Mysql 4.0.18?
select a.vendornumber from vendor a
where a.vendornumber not in
(select b.vendornumber from po b)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.