No subject

[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.



_______________________________________________
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