LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » Obsolete Join syntax

Obsolete Join syntax

Options

Previous Topic · Next Topic

George_B

Posted: Monday, February 01, 2010 7:04:19 PM

Rank: Newbie

Joined: 2/1/2010
Posts: 1
Points: 3
Where do you live?: Australia

Hi All

I'm attempting to convert an SQL Server Pass through query in an Access 2003 database to a SQL Server 2005 query and I'm not sur about the syntax of the join.

The query is like

select table1.field1, table1.field2, table2.field3
from table1, table2
where table1.field1 = table2.field1(+)
and ...

Is this a right outer join?

I have searched the net for and answer and haven't found much. The closest I can get is this type of join is specific to Oracle.

Thanks
George_B

Scott Whigham

Posted: Friday, February 26, 2010 8:46:24 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 466
Points: 1,020
Where do you live?: Dallas, TX

Hi there -

I've never seen that syntax!

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.