• SQLSACT (9/17/2012)


    Hi All

    Consider the following 2 tables

    create table T1

    (Col1 int, Col2 int)

    go

    create table T2

    (Col3 int, Col4 int)

    And the following query

    select Col1, Col4 from T1,T2

    What is actually happening when the select statement is executed? Is it an inner join or left join?

    Thanks

    Neither inner nor left join. It would be a cross join.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂