I see what you're saying, but that example was cribbed straight from bol, and given that this 'extension' syntax is so picky it fails if you use 'p.DefEAddres' I just use it as is.
- AndyD 8-)#
[EMAIL PROTECTED]
ribbers.com To: [EMAIL PROTECTED]
Sent by: cc:
profoxtech-bounces Subject: RE: [NF] SQL Server
commands
@leafe.com
16/08/2006 18:04
Please respond to
profox
> From: Andy Davies <[EMAIL PROTECTED]>
> I *always* have problems with these on SQL Server - but bol to the
rescue:
>
> try:
>
> UPDATE persons
> SET DefEAddres=em.EAddress
> FROM persons p, EmailAdd em
> WHERE p.PersonId = em.PersonId
> AND em.Type = 'PRIVATE'
>
> n.b. NOT p.DefEAddres
Andy, you should create the join instead of putting it's clause in the
where.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
