1272
1272
select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;
1299
1299
insert into t2 (fld1, companynr) values (999999,99);
1300
1300
select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;