select csm_name as ftm_name,csm_address1 as ftm_baddress,csm_address2 as ftm_baddress2,csm_city as ftm_bcity,csm_state as ftm_bstate, csm_country as ftm_bcountry,csm_phone as ftm_bphoneno,csm_zip_post as ftm_bzip_postal, cnt_name from customer_mst, country_mst where cnt_id=csm_country and csm_userid=select csm_contectperson as ftm_name,csm_shipaddress as ftm_saddress,csm_shippingaddress2 as ftm_saddress2,csm_shipcity as ftm_scity, csm_shipstate as ftm_sstate,csm_shipcountry as ftm_scountry,csm_shipphno as ftm_sphno, csm_shipzip_post as ftm_szip, cnt_name from customer_mst, country_mst where csm_shipcountry = cnt_id and csm_userid=