how can I add a 'WHERE product.ethical = '1'?
by adding it after the FROM clause, just before the ORDER BY clause
I tried that, but it caused an error...
Here's my query: SELECT distinct products.id,
try it without DISTINCT
Cause duplicated galore!
inner join categories as child on child.type = '5'
you realize that every single product will join with ~all~ categories of
type 5
this is called a "cross join effect"
Yes.. but I've got a filter in place, so it's all good...
would you kindly identify every join relationship as to whether it is
one-to-many, one-to-one, or many-to-one The wholt thing works great now.. APART from the ethical filter. hit mens on the left.. http://hypedev.co.uk/moretvicar/ You'll see that cetegories is filterable, but ethical is not.. does this help? ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
