Hi,
We are in the process of buying a new server to run mssql. However
before this as a tempory fix to using a msaccess backend i believe
through odbc i need to address the following issue:
SELECT ai.entry_date as CallTime,
ai.agent_login as AgentsLogin,
ai.campaign as MarketingCampai gn,
ai.agent_input2 as ProductsSold,
ai.first_name as Cust_FirstName,
ai.last_name as Cust_LastName,
ai.agent_input1 as Cust_PersonalNu mber,
ai.street_addre ss as Cust_AddressStr eet,
ai.city as Cust_AddressCit y,
ai.state as Cust_AddressSta te,
ai.zip as Cust_AddressZIP ,
rec.file_name as AgreementRecord ingFile
FROM agent_input ai, leads l, recordings rec
WHERE ai.whole_phone_ number = l.whole_phone_n umber AND
l.call_status = 1110 AND
rec.whole_phone _number = l.whole_phone_n umber AND
rec.last_name = l.last_name AND
rec.agent = ai.agent_login AND
rec.campaign = l.campaign AND
last_call_date between #04/24/2006 12:00 AM# and #04/25/2006 11:59 PM#
ORDER BY ai.agent_login, ai.entry_date
I want to make the recordings entry optional so the same results come
out whether it matches a recording or not. If it does i want it to
populate the AgreementRecord ingFile column above, if not just put a ''
as you would with '' as AgreementRecord File.
Does anyone know how you can do this, in a access based database system
using SQL through i believe ODBC?
Thanks
David