From lojban-out@lojban.org Thu Jun 03 18:21:57 2004 Return-Path: X-Sender: lojban-out@lojban.org X-Apparently-To: lojban@yahoogroups.com Received: (qmail 70965 invoked from network); 4 Jun 2004 01:21:56 -0000 Received: from unknown (66.218.66.217) by m21.grp.scd.yahoo.com with QMQP; 4 Jun 2004 01:21:56 -0000 Received: from unknown (HELO chain.digitalkingdom.org) (64.81.49.134) by mta2.grp.scd.yahoo.com with SMTP; 4 Jun 2004 01:21:56 -0000 Received: from lojban-out by chain.digitalkingdom.org with local (Exim 4.32) id 1BW3P4-0002NG-Om for lojban@yahoogroups.com; Thu, 03 Jun 2004 18:21:50 -0700 Received: from dsl081-049-134.sfo1.dsl.speakeasy.net ([64.81.49.134] helo=chain.digitalkingdom.org) by chain.digitalkingdom.org with esmtp (Exim 4.32) id 1BW3OO-0002MV-Ex; Thu, 03 Jun 2004 18:21:08 -0700 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 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 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 X-list: lojban-list To: lojban@yahoogroups.com X-eGroups-Remote-IP: 64.81.49.134 X-eGroups-From: Robin Lee Powell From: Robin Lee Powell Reply-To: rlpowell@digitalkingdom.org Subject: [lojban] Urgent: SQL help for BPFK. X-Yahoo-Group-Post: member; u=116389790 X-Yahoo-Profile: lojban_out X-Yahoo-Message-Num: 22493 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