I am trying to insert customer ids into an activity table that relates to customers thru the person table. It's very strange has to do with the data I'm trying to migrate from one database to another. The following select statement works or seems to...
SELECT `customer`.`cus t_id`
FROM `f_agent`.`cust omer`
LEFT JOIN `f_agent`.`pers on`
ON `customer`.`cus t_person_id` = `person`.`perso n_id`
LEFT JOIN `f_agent`.`acti vity`...
krisc13
Last Activity: Oct 23 '06, 08:54 PM
Joined: Oct 20 '06
Location:
-
order by slowing down query
I have the following select statement:
SELECT DISTINCT
cust_id,
cust_priority priority,
person_name_fir st f_name,
person_name_las t l_name,
person_email_pr imary email,
person_address_ a address,
person_address_ a2 address_2,
person_address_ a_city city,
person_address_ a_zip zip,
person_address_ a_state state,
customer__group .cust_group_id group_id,
customer__group .cust_group_sha red_by...
No activity results to display