XLODBC
1
DSN=XSTUDIO;
SELECT table_sut_0.sut_id, table_sut_0.sut_name, table_sut_data_0.sut_version, table_req_int_0.requirement_id, table_req_int_0.requirement_name, table_req_int_data_0.date_submitted, table_req_int_data_0.priority  FROM xstudio_db.table_req_int table_req_int_0, xstudio_db.table_req_int_data table_req_int_data_0, xstudio_db.table_req_int_data_tag table_req_int_data_tag_0, xstudio_db.table_sut table_sut_0, xstudio_db.table_sut_data table_sut_data_0, xstudio_db.table_sut_data_tag table_sut_data_tag_0, xstudio_db.table_sut_req table_sut_req_0, xstudio_db.table_sut_req_tag table_sut_req_tag_0  WHERE table_sut_data_0.sut_id = table_sut_0.sut_id AND table_sut_data_tag_0.data_id = table_sut_data_0.data_id AND table_req_int_data_0.requirement_id = table_req_int_0.requirement_id AND table_req_int_data_tag_0.data_id = table_req_int_data_0.data_id AND table_sut_req_0.requirement_id = table_req_int_0.requirement_id AND table_sut_req_0.sut_id = table_sut_0.sut_id AND table_sut_req_tag_0.link_id = table_sut_req_0.link_id AND ((table_sut_data_tag_0.tag_id=10) AND (table_req_int_data_tag_0.tag_id=10) AND (table_sut_req_tag_0.tag_id=10))


sut_id	sut_name	sut_version	requirement_id	requirement_name	date_submitted	priority