ACTUAL:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf atc 
left join akh_test_suit ats on ats.id = atc.test_suit_id) tc1
left join (select atc.id, ats.test_suit_type_id from akh_testing_conf atc left 
join akh_test_suit ats on ats.id = atc.test_suit_id) tc2 on 
tc2.test_suit_type_id = tc1.test_suit_type_id
where tc1.id = 3879

FEATURED:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf atc 
left join akh_test_suit ats on ats.id = atc.test_suit_id) tc1
left join tc1 tc2 on tc2.test_suit_type_id = tc1.test_suit_type_id
where tc1.id = 3879

Reply via email to