I paste this code into the SQL section to use for import�
select c.Brand, c.FirstName,c.LastName,c.City,c.State,c.Zip, c.Phonenumber,c.flag,c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2,c.q7a
from pmusa c
join i3_PMUSA_ch0 h
on c.i3_rowid = h.i3_rowid
where c.ContactDispo = 'success' and h.finishcode = 'success'
and h.callplacedtime between '02/01/2010' and '02/06/2010'
union
select c.Brand, c.FirstName,c.LastName,c.City,c.State,c.Zip, c.Phonenumber,c.flag,c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2,c.q7a
from PM_Revision c
join i3_PM_Revision_ch0 h
on c.i3_rowid = h.i3_rowid
where c.ContactDispo = 'success' and h.finishcode = 'success'
and h.callplacedtime between '02/01/2010' and '02/06/2010'
______________________________________________________________
I test and it works great but it converts to this code below. What can I do to keep the code listed above with it converting automatically to what�s listed below?
_______________________________________________________________
SELECT c.Brand, c.FirstName, c.LastName, c.City, c.State, c.Zip, c.Phonenumber, c.flag, c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2, c.q7a
FROM pmusa c
INNER JOIN i3_PMUSA_ch0 h
ON c.i3_rowid = h.i3_rowid
WHERE (c.ContactDispo = 'success') AND (h.finishcode = 'success') AND h.callplacedtime BETWEEN '02/01/2010' AND '02/06/2010'
Thank you,
Gary
select c.Brand, c.FirstName,c.LastName,c.City,c.State,c.Zip, c.Phonenumber,c.flag,c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2,c.q7a
from pmusa c
join i3_PMUSA_ch0 h
on c.i3_rowid = h.i3_rowid
where c.ContactDispo = 'success' and h.finishcode = 'success'
and h.callplacedtime between '02/01/2010' and '02/06/2010'
union
select c.Brand, c.FirstName,c.LastName,c.City,c.State,c.Zip, c.Phonenumber,c.flag,c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2,c.q7a
from PM_Revision c
join i3_PM_Revision_ch0 h
on c.i3_rowid = h.i3_rowid
where c.ContactDispo = 'success' and h.finishcode = 'success'
and h.callplacedtime between '02/01/2010' and '02/06/2010'
______________________________________________________________
I test and it works great but it converts to this code below. What can I do to keep the code listed above with it converting automatically to what�s listed below?
_______________________________________________________________
SELECT c.Brand, c.FirstName, c.LastName, c.City, c.State, c.Zip, c.Phonenumber, c.flag, c.agent_firstname, c.agent_lastname, c.contact_id, c.CCN, c.q2, c.q7a
FROM pmusa c
INNER JOIN i3_PMUSA_ch0 h
ON c.i3_rowid = h.i3_rowid
WHERE (c.ContactDispo = 'success') AND (h.finishcode = 'success') AND h.callplacedtime BETWEEN '02/01/2010' AND '02/06/2010'
Thank you,
Gary
Comment