SQL Query To Pull Contact Info for Additional Contacts 1

[captrick]

I am working on a SQL Qurey to pull this information from the Contact1 and Contsupp tables, but I am not having any luck:

Contact Name for subcontacts
Address of subcontact
Customer Name
City
State
Zip

Any help would be highly appreciated.

 

[RobColborne]

Hi

Try the following

Select Company, contsupp.contact, contsupp.Address1, contsupp.Address2, contsupp.city, contsupp.State, contsupp.Country,contsupp.Zip from contact1,contsupp where rectype = 'C' and contact1.accountno = contsupp.accountno

 

[captrick]

Thank you. I finally figured out the record type thing...seems our vendor forgot to inform me that the contsupp table stores different information in the fields than you would think on first look....LOL