Jump to content

markuswinter

Members
  • Posts

    2
  • Joined

  • Last visited

markuswinter's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Thanks. It's not my SQL, I was just curious what the || meant. But I'll pass it on.
  2. 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?
×
×
  • Create New...