Hi,

I am using union query, query is execute in phpmyadmin correctly and get result but when using in grid it's not showing the result can u plz help me???

Here is the query:

SELECT `customer_refer_id`,`first_name`,`last_name`,`zipcode`,`customer_territory`,
`customer_presence`,`open_quote`,`api_status`,`siebel_id`,`inbound_source`,`lead_generator`,`created_date`,`updated_date`,`work_phone_ext`,'' as `cust_hist_id`,'' as `insert_date`,'' as `cust_hist_status`,'' as `insert_by`,'' as `media_code`,'' as `product` from `lms_customer_details` UNION SELECT `customer_refer_id`,`first_name`,
`last_name`,`zipcode`,'' as `customer_territory`,'' as `customer_presence`,'' as `open_quote`,'' as `api_status`,'' as `siebel_id`,'' as `inbound_source`,'' as `lead_generator`,'' as `created_date`,'' as `updated_date`,'' as `work_phone_ext`,
`cust_hist_id`,`insert_date`,`cust_hist_status`,`insert_by`,`media_code`,`product` from `lms_customer_history`";