This ran without error:
select p.mls_number
from properties p
where (p.mls = 'hmls')
and (p.mls_number not in ( select pc.mls_number
from properties_copy pc
where pc.mls = 'hmls' ))
But, again, there's 0 records in the result set.
-----Original Message-----
From: Maureen [mailto:[email protected]]
Sent: Sunday, October 03, 2010 4:56 PM
To: cf-talk
Subject: Re: Can't figure out a query to accomplish this...
On Sun, Oct 3, 2010 at 12:12 PM, Rick Faircloth
<[email protected]> wrote:
> How can I write this to make it work?
>
> select p.mls_number
> from properties p
> where p.mls = 'hmls'
> and p.mls_number not in (select pc.mls_number from properties_copy pc
> where pc.mls = 'hmls')
>
> Any kind suggestions for a weary soul?
It looks right but try this:
select p.mls_number
from properties p
where (p.mls = 'hmls')
and ( p.mls_number not in (select pc.mls_number from properties_copy pc
where pc.mls =
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
