Interested in PostgreSQL? Try PGCon
the week after BSDCan.
|
|
Author: Dan
Date: 15-03-12 12:34
delete from forums_auth where ID NOT IN
(
select FA.id
from forums_auth FA JOIN bsdcan2007 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN bsdcan2008 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN bsdcan2009 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN bsdcan2010 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN bsdcan2011 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN bsdcan2012 F on (F.userid = FA.id)
);
|
|
Reply To This Message
|
|
|
Google+
Facebook
Twitter
