sql - Nested joins hide table names -

I have three tables: Suppliers, Parts and Types in three tables with the same name (say, "id") Along with the column discrimination, I need to get involved in all of them. I would like to successfully run this query:

  Choose Everything as Supplier, Supplier, Parts Parts, Parts. Description, type. Type as type. Join the Supplier as Type (Part Type Join Parts at Parts.type_id = Types.id) at Suppliers.id = Parts.supplier_id;  

My DBMS complains that "there is no such column (Part. Id)". I think that once the table name is forgotten, after joining, but then I column parts How can I see it?

Your ANSI-92 JOIN syntax is incorrect - Use:

  Sealed Suppliers. See everything as Suppliers, Type Parts.id, Parts.description, Type.typedesc as Type Type Suppliers.id = Parts.supplier_id type on parts at the supplier. Type_ind = type.id