Paul Giesenhagen wrote:
>
> I want a list of all the options that are not associated with the
> #url.productid# (found in the product options table, productid column).
>
> So if the option table has id's 1,2,3,4
>
> and the product options table have
> optionid, productid
> 2 3
> 4 3
>
> And url.productid = 3, I only want option id 1 and 4
I presume that is 1 and 3?
> I cannot use a sub query (already have that one working fine, this is for
> mySQL).
SELECT
o.id,
o.name,
o.description
FROM
options o
LEFT OUTER JOIN products po
ON (po.optionid = o.id AND po.productid = #url.productid#)
WHERE
po.productid IS NULL
But I'm getting the impression MySQL is feature challenged for your
application. You might want to consider upgrading if you still can.
Jochem
______________________________________________________________________
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
