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`


`store_product_profile` and `mail_order_cart`

SELECT `store_product_profile`.`product_name`
INNER JOIN `paypal_cart_info` ON `store_product_profile`.`reference` =
INNER JOIN `mail_order_cart` ON `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.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to