markuswinter

Thanks.

It's not my SQL, I was just curious what the || meant. But I'll pass it on.

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?