Oh man, that works! You rock!

Thanks, Matt

Thank you all.

I'm going to have to create an ancillary table with 7 notification (child) records for each Customer record.

Can anyone help me with a query that can insert these...

Thank you all... now I'm convinced! I'm going to use an ancillary table.

Thanks again,

Matt

I've thought about it some more, and to create an ancillary table seems like much more work. If I have 12 different newsletters then each time a Customer record...

Hmm.. thank you!

Thanks Alan! You rock.

Thanks guys! Especially Dwain - funny as well!

I respect your wish to have structured forum dialog, but it appears that, for this relatively simple question, helpful suggestions are possible without INSERT INTO and CREATE TABLE samples.

Thank you very much Scott! - Matt

Thank you very much Dwain! You are certainly the MAN with respect to SQL. I will consider all your helpful advice.

Matt

Thank you very much for your help Dwain. Yes, I do need stuff out of those other JOINS. I'll have to consider things..

Wow, that OUTPUT keyword is new to me. Thanks.

Followup question though, if you don't mind. My SELECT statement is pretty complex (used for paging through results in web page)....

Thank you Dwain!

Ok thank you all, I will digest this! I appreciate it.

I think this might work:

INNER JOIN ZipCodes Z ON (D.MainZip = Z.Zip OR D.AlternateZip = Z.Zip)