Sql Operator - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Sql Operator

Author

Topic

Renu Rathor
Starting Member

4 Posts

Posted - 2008-04-30 : 07:42:05

I am working with Sql quesries and trying to get the result of *=.
Can anybody tell how to use this and what would be the result of using it?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-30 : 08:13:56

You should learn to NOT use *= syntax.
Learn proper ANSI syntax

LEFT JOIN
RIGHT JOIN

INNER JOIN
CROSS JOIN
FULL JOIN

E 12°55'05.25"
N 56°04'39.16"

Renu Rathor
Starting Member

4 Posts

Posted - 2008-04-30 : 08:16:22

wht would be the result if i used it successfully?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-30 : 08:18:54

Read about joins in sql books online.

Renu Rathor
Starting Member

4 Posts

Posted - 2008-04-30 : 09:50:46

Wht if i wanna use?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-30 : 10:05:30

quote:
Originally posted by Renu Rathor

Wht if i wanna use?

Depends on your requirement. May i ask you what you are trying to achieve?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-30 : 10:06:26

They query will fail when run in SQL Server 2005.

The query uses non-ANSI outer join operators ("*=" or "=*").
To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel.
It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN).
In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.

E 12°55'05.25"
N 56°04'39.16"

Renu Rathor
Starting Member

4 Posts

Posted - 2008-05-01 : 05:48:18

So that means we cant use *=?

For any reslut set, which involve selection or conditions on different tables, only joins can be used.

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2008-05-01 : 08:01:43

Renu,
Why would you want to use *=? Do you not understand the error message that Peso provided and its ramifications?

An infinite universe is the ultimate cartesian product.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources