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
Please login or Register to submit your answer