table join - not unique table/alias

brettacvh

Forgive me for posting i two places but I'm on a major deadline :o

I am trying to join two tables i.e. tbl_photos and tbl_photos_products

Can somebody please tell me why the following query is giving me the error: "Not unique table/alias: 'tbl_photos_products' ?

SELECT tbl_photos., tbl_photos_products.
FROM tbl_photos, tbl_photos_products
LEFT JOIN tbl_photos_products ON tbl_photos_products.product_ID = tbl_photos.product_ID

In fact I need to join 3 tables: tbl_photos, tbl_photos_products and tbl_photos_brands, but I need to get the first part of the query correct first.

amit_patel

brettacvh;10903522 wrote:
Forgive me for posting i two places but I'm on a major deadline :o

I am trying to join two tables i.e. tbl_photos and tbl_photos_products

Can somebody please tell me why the following query is giving me the error: "Not unique table/alias: 'tbl_photos_products' ?

SELECT tbl_photos., tbl_photos_products.
FROM tbl_photos, tbl_photos_products
LEFT JOIN tbl_photos_products ON tbl_photos_products.product_ID = tbl_photos.product_ID

In fact I need to join 3 tables: tbl_photos, tbl_photos_products and tbl_photos_brands, but I need to get the first part of the query correct first.

Hy you may try these

select tp.* from tbl_photos tp LEFT JOIN tb_photos_product tpp ON tpp.product_ID = tp.product_ID

brettacvh

I figured it out:

SELECT tbl_photos., tbl_photos_products.
FROM tbl_photos
LEFT JOIN tbl_photos_products ON tbl_photos_products.product_ID = tbl_photos.product_ID
LEFT JOIN tbl_photos_brands ON tbl_photos_brands.brand_ID = tbl_photos.brand_ID
WHERE tbl_photos.brand_ID = 2

brettacvh

The only problem is that now tbl_photos_brands and tbl_photos_products are not returning anything. Any suggestions?

Weedpacket

Duplicate threads merged and moved to the appropriate forum.

brettacvh

Can somebody please tell me how to join the three tables and retrieve the rows from all three tables. Thanks.

Weedpacket

Well, you mention aliases; if you didn't know what they were did you look them up in the documentation to find out?

The problem is you're joining tbl_photos, tbl_photos_products, and tbl_photos_products together, so there'll be two "tbl_photos_products.product_ID" fields in every matching record. So when you say "tbl_photos_products.product_ID = tbl_photos.product_ID" which "tbl_photos_products.product_ID" do you mean?