Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2CF299FB364 for ; Thu, 26 Jul 2007 22:39:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 78738-02 for ; Thu, 26 Jul 2007 22:39:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54307.mail.re2.yahoo.com (web54307.mail.re2.yahoo.com [206.190.49.117]) by postgresql.org (Postfix) with SMTP id 6BA9B9FB2B8 for ; Thu, 26 Jul 2007 22:39:33 -0300 (ADT) Received: (qmail 64752 invoked by uid 60001); 27 Jul 2007 01:39:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=KuJeqfZGpE0JHSv2F2vUlx8z+wSAR2ipfXyS1J8sllLJL/kEH6y82u9WcB0WEuougfWYFTYaqHcbPb1GaOdJeAcNGzd/h0Qn0Lgrfk5V1Qt8qo9zl7aKY6KR8MsbDAq34nwRLbMI4M7I0Qsn2KRE+xXANsR3/SD4tfYwXjkaGwk=; X-YMail-OSG: iqkIWIIVM1nwsHQo2Yq5.eNI8bIIR1uEHQ4S4f0LBopyUO2CfGrme1.x8b_t6KhxwA-- Received: from [75.41.74.118] by web54307.mail.re2.yahoo.com via HTTP; Thu, 26 Jul 2007 18:39:31 PDT Date: Thu, 26 Jul 2007 18:39:31 -0700 (PDT) From: chester c young Subject: problem join To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <820562.64742.qm@web54307.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/159 X-Sequence-Number: 28894 having problem joining these correctly: schedule - cal_id references calendar not null - usr_id references users not null = unique( calZ_id, usr_id ) - result_no not null activity - cal_id references calendar not null - usr_id references users not null = unique( cal_id, usr_id ) - from_ts timestamp not null trying to join - cal_id - usr_id - schedule.result_no (might be null) - activity.from_ts (might be null) where schedule.usr_id = activity.usr_id would result in one row thanks for insight! ____________________________________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz