Can't you just do this?
SELECT p.mls_number
FROM properties p LEFT OUTER JOIN
properties_copy pc ON p.mls = pc.mls
WHERE pc.mls IS NULL
AND p.mls = 'hmls' (wouldn't need this bit unless you really only
want the 'hmls' records)
On 10/3/2010 3:12 PM, Rick Faircloth wrote:
> 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')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:337798
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
