[MySQL] Kolumna jest dwuznaczna Opcje

[lukko]

Układam sobie zapytanie do oscommerce:

Kod

$pytanie = tep_db_query("SELECT shops_id, products_id, stock, shops_name FROM shops_stocks INNER JOIN shops ON (shops_stocks.shops_id = shops.shops_id) WHERE products_id = '" . (int)$product_info['products_id'] . "';");

Łącze dwie tabele jak opisano: http://it.dth.pl/select-from-inner-join-ri...ql-mysql-cz-4c/ :-)

Wywala mi:

1052 - Column 'shops_id' in field list is ambiguous


Nie wiem jak ten błąd obsłużyć, jakaś sugestia ?

[lukko]

Chce ze shops_stocks

Czyli jak załączyć tą tabele ON (shops_stocks.shops_id = shops.shops_id) - zły ten warunek ale jak by miał wyglądać poprawnie?

W tym moim zapytaniu:

Kod

$pytanie = tep_db_query("SELECT shops_id, products_id, stock, shops_name FROM shops_stocks INNER JOIN shops ON (shops_stocks.shops_id = shops.shops_id) WHERE products_id = '" . (int)$product_info['products_id'] . "';");