markuswinter
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by markuswinter
-
-
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?
What does || mean in SQL?
in SQL
Posted
Thanks.
It's not my SQL, I was just curious what the || meant. But I'll pass it on.