No subject


Thu Dec 29 10:16:19 CST 2011


[WHERE <search_condition> | <old_outer_join>]
<old_outer_join> ::=	column_name { *= | =* } column_name

Arguments

<search_condition>

Restricts the rows returned in the result set through the use of predicates. There is no 
limit to the number of predicates that can be included in a search condition. For more 
information about search conditions and predicates, see Search Condition. 

<old_outer_join>

Specifies an outer join using the nonstandard product-specific syntax and the WHERE 
clause. The *= operator is used to specify a left outer join and the =* operator is used to 
specify a right outer join. 
This example specifies a left outer join in which the rows from Tab1 that do not meet 
the specified condition are included in the result set:

SELECT Tab1.name, Tab2.idFROM Tab1, Tab2WHERE Tab1.id *=Tab2.id

Note  Using this syntax for outer joins is discouraged because of the potential for 
ambiguous interpretation and because it is nonstandard. Instead, specify joins in the 
FROM clause. 

It is possible to specify outer joins by using join operators in the FROM clause or by 
using the non-standard *= and =* operators in the WHERE clause. The two methods 
cannot both be used in the same statement."



> No that's actually multiplying the value and setting it eqaal to the left
> side of the equation.
> 
> Var1 *= Var2 is the equivalent of Var1 = Var1 * Var2
> 
> Works in VB but not VBA (There are others like +=, /=, etc....)
> 
> Chris Mackin
> www.denverdb.com
> Denver Database Consulting, LLC
> 
> 
> -----Original Message-----
> From: dba-sqlserver-admin at databaseadvisors.com
> [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Susan
> Harkins
> Sent: Thursday, March 06, 2003 6:57 PM
> To: SQLList
> Subject: [dba-SQLServer]* in field name?
> 
> 
> where     bc.carrera=a.carrera
> and bc.plan_estud=a.plan_estud
> and a.boleta*=k.boleta
> 
> =======Ran across what appears to be an unusual syntax -- the use of * in a
> field name? Is that what this is? What does this mean or am I
> misunderstanding what I'm seeing?
> 
> Susan H.
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.






More information about the dba-SQLServer mailing list