Some HELP with MS SQL

Lenny77 · #1 (**permalink**) 10-25-10, 11:28

What is the equivalent between DB2 JOIN TABLE and MS SQL :

In DB2:

Code:

select * from
table1 t1 
JOIN TABLE
(select t2.* from table2 t2
where t2.clmn2 = t1.clmn1
and t2.clmn3 = t1.clmn3) tt
on  1 = 1

Show me how it'll look in MS SQL .

Thanks

r937 · #2 (**permalink**) 10-25-10, 12:05

wow, that's weird

Code:

SELECT * 
  FROM table1 AS t1 
INNER
  JOIN table2 AS t2
    ON t2.clmn2 = t1.clmn1
   AND t2.clmn3 = t1.clmn3

pootle flump · #3 (**permalink**) 10-25-10, 12:21

Please don't double post Lenny. I've locked this one.