At 6:47 PM +0200 5/22/08, hubert depesz lubaczewski wrote:
On Thu, May 22, 2008 at 12:21:35PM -0400, Owen Hartnett wrote:
The SQL I've tried is:
select commcost.maplot, commcost.unitno from commcost
where not exists(select 1 from commcost, bldg
where commcost.maplot = bldg.maplot and
commcost.unitno = bldg.unitno)
order by commcost.maplot
change it to:
select commcost.maplot, commcost.unitno from commcost
where not exists(select 1 from bldg
where commcost.maplot = bldg.maplot and
commcost.unitno = bldg.unitno)
order by commcost.maplot
or simply write:
select * from commcost except select * from bldg;
depesz
Thank you very much for your quick response!
-Owen
