How about
WHERE (po.productid IS NULL) OR (po.productid NOT IN
('#url.productid#'))
> -----Original Message-----
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 26 September 2002 3:43 p.m.
> To: CF-Talk
> Subject: Re: JOIN Query (with query)
>
>
> Odd the query didn't go through.. here it is again:
>
> SELECT o.id, o.name, o.description
> FROM #request.optionTable# o
> LEFT OUTER JOIN #request.productOptionTable# po
> ON po.optionid = o.id
> WHERE po.productid NOT IN ('#url.productid#')
>
>
> > I am trying to run a query that joins two tables and
> returns all the items
> that are listed in the optionTable, BUT NOT the ones who have
> the productid
> of the url.productid in the productOption table.
> > (o.id = po.optionid)
> >
> > Here is the query I have thus far and it returns no results .. if I
> replace NOT IN with = '#url.productid#' it returns all the options
> associated with that product.
> >
> >
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
