Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Question Unanswered: Some HELP with MS SQL

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Please don't double post Lenny. I've locked this one.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •