SQL = "SELECT " _ & "RentRezTable.f_rent_rez_d_start, RentRezTable.f_rent_rez_d_end, RentRezTable.f_rent_veh_vin, RentRezTable.f_rent_veh_make, RentRezTable.f_rent_sales_registr, RentRezTable.f_rent_pri_xls_retial_net_mnt, RentRezTable.f_rent_calc_ro_retdelfee, RentRezTable.f_rent_calc_km_lim_dd, RentRezTable.f_rent_calc_km_overfee_rate, RentRezTable.f_rent_doc_num, RentRezTable.f_rent_doc_lit, RentRezTable.f_rent_doc_year, RentRezTable.f_rent_doc_dat, RentRezTable.f_rent_doc_c_user_name, " _ & "union_customer_crm.f_cli_c_typ_desc, union_customer_crm.f_cli_r_clt_int, union_customer_crm.f_cli_r_clt_reg_1, union_customer_crm.f_cli_r_clt_reg_2, union_customer_crm.f_adr_r_adr_1, union_customer_crm.f_adr_r_adr_2, union_customer_crm.f_adr_l_twn, union_customer_crm.f_adr_c_post_code, " _ & "union_customer_crm_1.f_adr_r_adr_1, union_customer_crm_1.f_adr_r_adr_2, union_customer_crm_1.f_adr_c_post_code, union_customer_crm_1.f_adr_l_twn " _ & "FROM " _ & pub_cr.glb_DSNName & ".." & "RentRezTable RentRezTable, " _ & pub_cr.glb_DSNName & ".." & "union_customer_crm union_customer_crm, " _ & pub_cr.glb_DSNName & ".." & "union_customer_crm union_customer_crm_1 " _ & "WHERE " _ & "RentRezTable.f_rent_vis_id = " & rent_vis_id & " AND " _ & "RentRezTable.f_rent_rez_pos = " & rent_rez_pos & " AND " _ & "RentRezTable.f_rent_cli_id = union_customer_crm.f_id AND " _ & "RentRezTable.f_rent_cm_cli_id = union_customer_crm_1.f_id" $sqlQuery = "SELECT RentRezTable.f_rent_rez_d_start, RentRezTable.f_rent_rez_d_end, RentRezTable.f_rent_veh_vin, RentRezTable.f_rent_veh_make, RentRezTable.f_rent_sales_registr, RentRezTable.f_rent_pri_xls_retial_net_mnt, RentRezTable.f_rent_calc_ro_retdelfee, RentRezTable.f_rent_calc_km_lim_dd, RentRezTable.f_rent_calc_km_overfee_rate, RentRezTable.f_rent_doc_num, RentRezTable.f_rent_doc_lit, RentRezTable.f_rent_doc_year, RentRezTable.f_rent_doc_dat, RentRezTable.f_rent_doc_c_user_name, union_customer_crm.f_cli_c_typ_desc, union_customer_crm.f_cli_r_clt_int, union_customer_crm.f_cli_r_clt_reg_1, union_customer_crm.f_cli_r_clt_reg_2, union_customer_crm.f_adr_r_adr_1, union_customer_crm.f_adr_r_adr_2, union_customer_crm.f_adr_l_twn, union_customer_crm.f_adr_c_post_code, union_customer_crm_1.f_adr_r_adr_1, union_customer_crm_1.f_adr_r_adr_2, union_customer_crm_1.f_adr_c_post_code, union_customer_crm_1.f_adr_l_twn FROM RentRezTable RentRezTable, union_customer_crm union_customer_crm, union_customer_crm union_customer_crm_1 WHERE RentRezTable.f_rent_doc_num = ".$rent_doc_num." AND RentRezTable.f_rent_doc_lit = '".$rent_doc_lit."' AND RentRezTable.f_rent_doc_year = ".$rent_doc_year." AND RentRezTable.f_rent_cli_id = union_customer_crm.f_id AND RentRezTable.f_rent_cm_cli_id = union_customer_crm_1.f_id";