Unanswered: insert problem, error: invalid column name
Can anybody plz help me?
I m getting this error,invalid column name. BUt the same works for mysql.
my query is:
insert into lp(lp_date, lp_mobile_no, lp_points) select '$date', a.um_mobile_no as Mobile, round((sum(a.um_count * (b.lw_weightage)))/10,2) as Points from un a,lw b where a.um_rep_date='$date' and length(a.um_mobile_no) >= 6 and a.um_category=b.lw_category and a.um_serv_provider=b.lw_operator and Points >0 group by a.um_mobile_no order by Points, Mobile desc ;