In a join condition it is mandatory to specify the table name along with the column name
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Is this a valid join condition written in the query below?
- There should be one condition within the WHERE clause for each pair of tables being joined.
- An outer join requires each record in the two joined tables to have a matching record.
- In RDBMS, one can NOT have two tables with the same column name
- When you create a join to a party table, the destination column must reference the _____column in the joine...
- Which of the following is NOT true of the Join Specification object type?
- Join condition in a joiner transformation is not mandatory.
- For tables joined on the same distribution key as in the JOIN clause, Distribution is not required