1441
1441
explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
1442
1442
id select_type table type possible_keys key key_len ref rows Extra
1443
1443
1 SIMPLE t4 index NULL PRIMARY 1 NULL 12 Using index; Using temporary
1445
1445
select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;
1446
1446
fld1 companynr fld3 period