FEATURE: Reuse temporary tables
Started by Eugen Konkovalmost 18 years ago1 messagesbugs
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