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.
| Author |
Topic |
|
MageshkumarM
Yak Posting Veteran
61 Posts |
 Posted - 2012-02-02 : 03:45:20
|
| Hi,Here i have a doubt,[ select * from table where column *= values ]what is the use of *= in where clause. how it wil work.Thanks,Magesh.Mhttp://mageshkumarm.blogspot.com/ |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-02-02 : 04:15:23
|
| Its not T-SQL, its Oracle I think, but as for what it does, it enforces a join condition (in this case I think a left join). |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-02 : 04:26:32
|
[select * from table, table2 where table.column *= table2.column]This is old T-SQL join syntax and it is no longer supported in SQL Server since version 2005.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
MageshkumarM
Yak Posting Veteran
61 Posts |
Posted - 2012-02-02 : 05:47:12
|
| Thanks guys.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-02 : 10:10:15
|
quote:
Originally posted by MageshkumarM
Thanks guys..
even for clarity sake, better to use left ,right join etc instead of *= and =* in earlier versions also------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
* in where clause.