[dba-SQLServer]* in field name?

Stuart,

I read about it the other day on MSDN and in trying to find it again I'm at
a loss, but will let you know if it does turn up.  I hadn't looked at the
specifics, but yes it does appear to Join related.  I think I was perusing
the .Net information when I saw the other way of using it.

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 Arthur
Fuller
Sent: Friday, March 07, 2003 5:50 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]* in field name?


AFAIK this c-style syntax was introduced in .Net. It's about time too, IMO!


-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: March 6, 2003 10:55 PM
To: Chris Mackin; dba-sqlserver at databaseadvisors.com; Susan Harkins
Subject: RE: [dba-SQLServer]* in field name?


What version of VB? I've never seen it in any earlier versions and it
doesn't work in
VB6.

In this case *=  is specifying a left outer join.