以前用过很复杂的sql语句,几年过去了,忘光了,要用的时候完全想不起来
记录一个以备忘:
select * from ( select * from t1 ) as t3, ( select * from t2 ) as t4 where t3.f1 = t4.f2
以前用过很复杂的sql语句,几年过去了,忘光了,要用的时候完全想不起来
记录一个以备忘:
select * from ( select * from t1 ) as t3, ( select * from t2 ) as t4 where t3.f1 = t4.f2