Sql query to find column matches across tables
Alberto last edited by
I have 3 tables. Within those 3 tables are the same column names: part name, supplier, part id
The issue is that multiple suppliers may have the same part ID and trying to query and show if a part ID or part name is associated with multiple suppliers?
You can qualify your tables/columns in your query to separate. It's difficult to imagine what you are trying to do without seeing a sample of the data.
You could also prefix/pipe in descriptive text in your id columns to help separate the ids.
`Select 'supplier1-' || id, 'supplier2-' || id2 From Table;