THANKYOU BEN!
I played with union and made it work so I will stick with that
:$ I have a script putting together the query, for multiple-keyword-searches it gets a bit messy
:O
quote:
(SELECT DISTINCT shops.* FROM shops, shops_products WHERE (shops_products.product LIKE '%35mm%') AND (shops_products.sid = shops.sid) OR (shops_products.product LIKE '%photography%') AND (shops_products.sid = shops.sid)) UNION (SELECT DISTINCT shops.* FROM shops, shops_products, shops_products_link WHERE ( (shops_products_link.child_title LIKE '%35mm%') AND ( shops_products.product = shops_products_link.parent_title ) AND (shops_products.sid = shops.sid) ) OR ( (shops_products_link.child_title LIKE '%photography%') AND ( shops_products.product = shops_products_link.parent_title ) AND (shops_products.sid = shops.sid) )) ORDER BY shopname LIMIT 0, 18