SQLSACT (9/17/2012)
Hi AllConsider 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
🙂