The following is a query I am working on today. I need help tweaking on it.
What I am trying to get for results from the query are where there are
rows in either table, not all 3 tables linked together.
In other words I am trying to INNER JOIN these two pairs of tables for
possible results:
`store_product_profile` and `paypal_cart_info`
OR
`store_product_profile` and `mail_order_cart`
SELECT `store_product_profile`.`product_name`
FROM (
`store_product_profile`
INNER JOIN `paypal_cart_info` ON `store_product_profile`.`reference` =
`paypal_cart_info`.`itemnumber`
)
INNER JOIN `mail_order_cart` ON `store_product_profile`.`reference` =
`mail_order_cart`.`store_product_profile_reference`
WHERE `store_product_profile`.`discontinued` =0
AND `store_product_profile`.`reference` =7
Finally I need help with the GROUP BY syntax also. I only want the name
of the product once, not if it was in several previous purchases.
Any help is appreciated.
Ron
|