Re: SQL Query

Posted in 1991

bochner@das.harvard.edu — Wed, 27 Nov 91 16:17:39 -0500 — source: Informix-list mailing list archive (1991-1998)

> When I user outer join then it says that it found 3 rows which is correct. > But is there anyway I can do my query to find the project_no from TABLE A > that is not in the TABLE B? So, my result should say only one row found > from TABLE A. Try something like this: select * from a where not exists (select project_no from b where b.project_no = a.project_no) -- Harry Bochner -- bochner@das.harvard.edu