Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL-forespørgsel - et lille problem

2 views
Skip to first unread message

Kurt Hansen

unread,
Jul 15, 2015, 12:52:24 AM7/15/15
to
Jeg har bl.a. disse tabeller:
products
manufacturers

Følgende virker:
SELECT products_id, products_model, products_date_added,
products_last_modified, manufacturers_name
FROM products, manufacturers
WHERE products.manufacturers_id = manufacturers.manufacturers_id

Nu vil jeg ændre lidt, så jeg i stedet for manufacturers trækker fra
products_description:

SELECT products_id, products_model, products_description
FROM products, products_description
WHERE products.products_id = products_description.products_id

- men får denne fejl:
#1052 - Column 'products_id' in field list is ambiguous

products_id findes i alle tabeller.

Hvad sker der lige?
--
Venlig hilsen
Kurt Hansen

Kurt Hansen

unread,
Jul 15, 2015, 12:58:43 AM7/15/15
to
Den 15/07/15 kl. 06.44 skrev Kurt Hansen:
Hmmm, fandt selv ud af det ved Fedtmulemetoden:

SELECT products.products_id, products.products_model,
products_description.products_description
FROM products, products_description
WHERE products.products_id = products_description.products_id
0 new messages