On Sun, Oct 3, 2010 at 12:12 PM, Rick Faircloth <ric...@whitestonemedia.com> 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:337805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm