SQL Query Help

[austin.rock9]

Hi in the user stats for OUTBOUND CALLS i want comments of particular leads and province of that lead in that list. How can i get that..I got the below query :

$stmt="select * from vicidial_log where user='" . mysql_real_escape_string($user) . "' and call_date >= '" . mysql_real_escape_string($begin_date) . " 0:00:01' and call_date <= '" . mysql_real_escape_string($end_date) . " 23:59:59' order by call_date desc limit 10000;";

How can i link vicidial_list to get comment and province from it.

Thanks

[mflorell]

Well, you don't want to select * then, pick the fields you want from vicidial_log and then add the fields you want from vicidial_list and put "vicidial_list.lead_id=vicidial_log.lead_id" after the where clause.

Take a look at the AST_VDsales_export.pl script for more ideas on this.