insert into flatlist(Name,Department_Text,StartDate,Active,EndDate,Title,Manager,Phone,Zip4,Zip5,ZipC,State,City,Address,DOB,Gender) SELECT Person.Name, Department.Department_Text, Internal.StartDate, Internal.Active,Internal.EndDate, Internal.Title, Internal.Manager, Personal.Phone, Personal.Zip4, Personal.Zip5, Personal.ZipC, Personal.State, Personal.City, Personal.Address, Personal.DOB, Personal.Gender FROM Department INNER...

Yes.

Thanks for the reply. Looks good!

Thanks. I have to be more careful of that stuff.

I'm reading it right now. It is a bit over my head though. I'm not quite that advanced yet. I see you can use ORDER BY but I don't really...

SELECT no SELCT. Lolll!!!!!!

Thank you. I love forums because I always get great responses like this one.

I have insert statement I will attach below. Sometimes funny characters come in and cause my insert to fail. I want to know what those characters are so I can...

Really great replies. I need to digest all of this material.

I read the documentation and it's very clear. Thank you very kindly for this wonderful post.

At first glance I can understand generally everything except 'IDENTITY(INT 1, 1)'. What is that doing exactly?