Please Help a Newbie

• Connie Michaels

  Grasshopper

  Points: 22

  More actions

  February 4, 2004 at 7:53 pm

  #160735

  I'm trying to learn t-sql coming from an Oracle background.

  Where can I learn the syntax for SELECT statents w.r.t. the LEFT JOIN, INNER JOIN, etc nomenclature that I'm not comfortable with yet!

  I'm very comfortable in Oracle's SQL and PL/SQL environment and I'm trying to springboard into SQL Server land.

  Your help is appreciated!

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 5, 2004 at 12:37 am

  #492840

  The first place to search is always Books Online (BOL). Look for SELECT or joins-SQL Server.

  The next place to search (ask) is here.

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• StephenMarais

  SSC-Addicted

  Points: 452

  More actions

  February 10, 2004 at 3:05 am

  #493347

  If you know Oracle syntax, this should suffice

  Left outer join

  Oracle = select * from table1, table2 where table1.field1 = table2.field1 (+)

  SQL = select * from table1 left outer join table2 on table1.field1 = table2.field1

  Right outer join

  Oracle = select * from table1, table2 where table1.field1 (+) = table2.field1

  SQL = select * from table1 right outer join table2 on table1.field1 = table2.field1

  Inner join

  Oracle = select * from table1, table2 where table1.field1 = table2.field1

  SQL = select * from table1 inner join table2 on table1.field1 = table2.field1

  full outer join

  Oracle = select * from table1, table2 where table1.field1 (+) = table2.field1 (+)

  SQL = select * from table1 full outer join table2 on table1.field1 = table2.field1

  Hope this helps, I had to make the transition from SQL to Oracle recently, so I faced similar prolems.

   

   

   

  Stephen Marais
  Integration Architect
  Digiata Technologies
  www.digiata.com