getting sql errors when I have 2 columsn that use a relationship (one column works fine)

Below the error, as you can see it's a complex view :-) I get this error once I set the country field to use the country relationship, without, it works fine (including a relationship on the client column).

user warning: Unknown column 'node_node_data_field_country.vid' in 'on clause' query: SELECT node.nid AS nid, node_data_field_quotation_nr.field_quotation_nr_value AS node_data_field_quotation_nr_field_quotation_nr_value, node_data_field_quotation_nr.nid AS node_data_field_quotation_nr_nid, node.type AS node_type, node.title AS node_title, node_node_data_field_client.title AS node_node_data_field_client_title, node_node_data_field_client.nid AS node_node_data_field_client_nid, node_data_field_country.field_country_nid AS node_data_field_country_field_country_nid, node_data_field_country.nid AS node_data_field_country_nid, node_node_data_field_country.type AS node_node_data_field_country_type, node_data_field_quotation_nr.field_status_nid AS node_data_field_quotation_nr_field_status_nid, node.vid AS node_vid, node_data_field_quotation_nr.field_company_nid AS node_data_field_quotation_nr_field_company_nid, node_data_field_quotation_nr.field_sensor_type_nid AS node_data_field_quotation_nr_field_sensor_type_nid, node_data_field_quotation_nr.field_base_solution_value AS node_data_field_quotation_nr_field_base_solution_value, users.name AS users_name, node_data_field_date_request.field_date_request_value AS node_data_field_date_request_field_date_request_value FROM idkr_node node LEFT JOIN idkr_content_type_quote node_data_field_client ON node.vid = node_data_field_client.vid LEFT JOIN idkr_node node_node_data_field_client ON node_data_field_client.field_client_nid = node_node_data_field_client.nid LEFT JOIN idkr_content_type_quote node_data_field_country ON node_node_data_field_country.vid = node_data_field_country.vid LEFT JOIN idkr_node node_node_data_field_country ON node_data_field_country.field_country_nid = node_node_data_field_country.nid LEFT JOIN idkr_content_type_quote node_data_field_quotation_nr ON node.vid = node_data_field_quotation_nr.vid INNER JOIN idkr_users users ON node.uid = users.uid LEFT JOIN idkr_content_type_quote node_data_field_date_request ON node.vid = node_data_field_date_request.vid WHERE node.type in ('quote') ORDER BY node_data_field_date_request_field_date_request_value DESC