Hi all,
I just came across the following SQL (aid and fid are two fields in both database tables):
delete from Table2 where aid || fid in (select aid || fid from Table1) ;
which is much faster than
delete from Table2 a where EXISTS( SELECT * FROM table1 b WHERE a.aid=b.aid AND a.fid=b.fid)
But what does || mean?