From rlpowell@digitalkingdom.org Thu Jun 03 18:21:05 2004 Received: with ECARTIS (v1.0.0; list lojban-list); Thu, 03 Jun 2004 18:21:05 -0700 (PDT) Received: from rlpowell by chain.digitalkingdom.org with local (Exim 4.32) id 1BW3OC-0002M9-2Q for lojban-list@lojban.org; Thu, 03 Jun 2004 18:20:56 -0700 Date: Thu, 3 Jun 2004 18:20:56 -0700 To: lojban-list@lojban.org Subject: [lojban] Urgent: SQL help for BPFK. Message-ID: <20040604012056.GE26987@chain.digitalkingdom.org> Mail-Followup-To: lojban-list@lojban.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.5.1+cvs20040105i From: Robin Lee Powell X-archive-position: 8042 X-ecartis-version: Ecartis v1.0.0 Sender: lojban-list-bounce@lojban.org Errors-to: lojban-list-bounce@lojban.org X-original-sender: rlpowell@digitalkingdom.org Precedence: bulk Reply-to: lojban-list@lojban.org X-list: lojban-list I have a table with message_id and in_reply_to. I need to select all rows that have an in_reply_to that is not equal to *any* message_id anywhere in the same table. This is MySQL, so I don't *think* I can use sub-selects. This is rather urgent, as it's breaking the BPFK boards. -Robin, who can never remember how to do this. -- http://www.digitalkingdom.org/~rlpowell/ *** I'm a *male* Robin. "Many philosophical problems are caused by such things as the simple inability to shut up." -- David Stove, liberally paraphrased. http://www.lojban.org/ *** loi pimlu na srana .i ti rokci morsi