Important conditions for joining two tables on a key?

Question

Joining two tables

in progress 0
TheDataMonk 55 years 4 Answers 2222 views Grand Master 0

Answers ( 4 )

    0
    Reply

    1) The data types of the columns involved in a join condition need to be compatible.
    2) A join condition involves columns that relate two tables in some logical way.
    3) The columns specified in a join condition need to be specified in the SELECT statement with table alias.

  2. Ognish
    3
    Reply

    Primary conditions for joining two tables on keys:
    1. The key column should contain non-NULL values
    2. The datatype of both tables’s column should be similar

  3. Sai
    1
    Reply

    Important conditions for joining 2 tables on a particular key :
    1. The data type has to be similar with respect to table columns.
    2. We need to use different Aliases for the columns with respect to the table name given in the select statement.

  4. sakshi31
    0
    Reply

    Before joining two tables points to remember-
    There should be no null values to avoid error.
    Data type of columns should be similar.

Leave an answer

Browse
Browse