SELECT   RTRIM(Accounts.ACCT_ID) AS AcctID
	,RTRIM(Accounts.ACCT_SSNUM) AS SSN
	,RTRIM(Accounts.ACCT_FIRST_NAME) AS FirstName
	,RTRIM(Accounts.ACCT_LAST_NAME) AS LastName
	,RTRIM(Accounts.ACCT_AD1) AS DeliveryAddress
	,RTRIM(Accounts.ACCT_AD2) AS SecondaryAddress
	,RTRIM(Accounts.ACCT_CITY) AS City
	,RTRIM(Accounts.ACCT_ST) AS STATE
	,RTRIM(Accounts.ACCT_ZIP) AS Zip
	,phone.numbers
	,RTRIM(Accounts.ACCT_DOB) AS dob
FROM Accounts
INNER JOIN CA1B ON Accounts.ACCT_ID = CA1B.CLNT_ACCT_REF
CROSS APPLY (
	SELECT RTRIM(PHNMBR_PHONE_NUMERIC) + ' '
	FROM Phone_Numbers
	WHERE Accounts.ACCT_ID = Phone_Numbers.PHNMBR_ACCT_ID
	FOR XML path('')
	) phone(numbers)
WHERE (Accounts.ACCT_CLIENT1 = 'joe')
	AND (Accounts.ACCT_DATE_ADDED = '20130122')
	AND (
		CA1B.DATETIME = '1/23/2013 9:57:47 AM'
		OR CA1B.DATETIME = '1/24/2013 9:12:19 AM'
		)