Two tables have columns with the same field names. What is required in order to join the two tables?

Two tables have columns with the same field names. What is required in order to join the two tables?Category: Introduction to Linux ITwo tables have columns with the same field names. What is required in order to join the two tables?
Linux Questions Staff asked 1 year ago

Two tables have columns with the same field names. What is required in order to join the two tables?

  • Change field names in one of the tables to make it unambiguous
  • Join between such tables cannot be created
  • Create a dummy table which has no common fields
  • Field names must be prefixed by the table name and a period

About the author