Create new table based on table of email addresses

[KennyRohan]

Does anyone have an SQL query allowing me to create a new table based on email addresses in a different table? Thank you.

 

[fneily]

What do you mean? You want to parse the email address into different fields? Or you just want a table of email addresses? But then again why? You'd have duplicate data in two different tables and that's against the protocols of normalization.

 

[KennyRohan]

Guess I was to brief with my question. I have a large file containing name, address, company, emailaddress, etc. I have a second file of ONLY emailaddresses. I wish to use this email-only second file as a means on extracting records in the bigger file, which has much more information in it. Thank you for your reply.

 

[BigRed1212]

If the second file is a subset of the email address records in the large file could you simply join, something like:

select largefile.*
from largefile right join emailonlyfile on largefile.email=emailonlyfile.email

or am I missing something?