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:
`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`";
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!