Over a million developers have joined DZone.

SQL Query For Contacts

·
// SQL query for contacts


// insert code here..
SELECT tblContacts.ContactID, [LastName] & ", " & [FirstName] AS ContactName, tblContacts.FirstName,
 tblContacts.LastName, tblContacts.Salutation, tblContacts.StreetAddress, tblContacts.City,
 tblContacts.StateOrProvince, tblContacts.PostalCode, tblContacts.Country, tblContacts.CompanyName,
 tblContacts.JobTitle, tblContacts.Use
FROM tblContacts
ORDER BY [LastName] & ", " & [FirstName];

Topics:

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}