sethbeckerman5 Staff asked 4 years ago
I have 3 tables vendors, components and catalog, here is the schema:
vendors – vid,vaddress,vname
components- cid, cname, type
catalog- cid, vid, cost
catalog is connected with the 2 tables with a foreign key vid and cid.
Query:
ERROR 1052 (23000): Column 'vid' in field list is ambiguous.
I am getting this error.
View on Stack Overflow