Re: append query record repeats

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the help, but I think I've got it now. Jason

jason.kohout@xxxxxxxxx wrote:
SQL (I'm a beginner, so this is from the grid):

INSERT INTO Individuals ( Firstname, Lastname, YOB, PhoneNumber,
AddressLine, City, Zip5, Zip4 )
SELECT import2.Firstname, import2.Lastname, import2.YOB,
import2.PhoneNumber, import2.AddressLine, import2.City, import2.Zip5,
import2.Zip4
FROM import2;

.

Relevant Pages

  • Re: append query record repeats
    ... AddressLine, City, Zip5, Zip4) ...
    (microsoft.public.access.queries)
  • Re: Modeling Address using Relational Theory
    ... > make sense to haul out some operators on the "addressLine" domain to ... For line-of-business projects I've always done Address1, city, state, zip. ... I find it much better to split out city/state/zip cuz you can get databases ...
    (comp.databases.theory)