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 |
|
Moozzie
Starting Member
17 Posts |
 Posted - 2008-02-05 : 07:42:12
|
| Hi foks!What does the sign *= do in a query?Here is an example:from table_1 cr , table_2 cp, table_3 eswhere cr.id = cp.id and cr.id *= es.idThis code is not mine but I yust want to learn the basics.Ty |
|
|
Moozzie
Starting Member
17 Posts |
Posted - 2008-02-05 : 07:51:11
|
| Left Join |
 |
|
|
Moozzie
Starting Member
17 Posts |
Posted - 2008-02-05 : 07:51:22
|
| Tank you :D |
|
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-02-05 : 08:03:38
|
| Use ANSI join syntax in your queries. instead of *= , use LEFT JOIN |
|
|
|
Moozzie
Starting Member
17 Posts |
Posted - 2008-02-05 : 08:25:15
|
| Oke i will do that, ty |
|
|
|
|
|
|
Meaning of *= in query