Sql query to find column matches across tables



  • 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;
    

Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2