![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
![]() |
Reported By: Greg Bishop Reported On: 4/14/2009 For: Version 2.02 Build 11 |
SELECT AddressID, Description, Address1, Address2, City, State, PostalCode, Country, True AS Primary FROM Address WHERE (AddressID IN (SELECT AddressID FROM ContactToAddress WHERE ContactID = :ContactID)) AND (:PrimaryPhysicalAddressID = AddressID) UNION SELECT AddressID, Description, Address1, Address2, City, State, PostalCode, Country, False AS Primary FROM Address WHERE (AddressID IN (SELECT AddressID FROM ContactToAddress WHERE ContactID = :ContactID)) AND (:PrimaryPhysicalAddressID <> AddressID)
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |