Re: [Emerald] SQL Question

Dale E. Reed Jr. ( (no email) )
Mon, 08 Feb 1999 09:17:49 -0800

Alexander Blauvelt wrote:
>
> Dale and other SQL gurus,
>
> The conversion program we have didn't convert a lot of the information
> when we converted from Access to Emerald. I'm using access to build an
> update queries to convert things like startdates and billing types. The
> problem is building a relationship between Access table and the SQL
> table and then update the right fields. I'm no SQL guru like dale, so
> I must rely on access to build statements for me. For example, I want
> to update the startdates from one system to the other, access generated
> me this sql statement:
>
> UPDATE dbo_MasterAccounts INNER JOIN MasterAccounts ON
> (dbo_MasterAccounts.LastName = MasterAccounts.LastName) AND
> (dbo_MasterAccounts.FirstName = MasterAccounts.FirstName) SET
> dbo_MasterAccounts.CreateDate = MasterAccounts.CreateDate
> WHERE (((MasterAccounts.CreateDate) Is Not Null));
>
> Would this update masteraccounts with the startdates from access ?

Yes, but unless you can gurantee that the combination of
FirstName and LastName are unique, the results might not be
what you expect.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html