X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2C1EBD98B8 for ; Fri, 14 Oct 2005 15:06:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58897-09 for ; Fri, 14 Oct 2005 18:06:30 +0000 (GMT) Received: from apollo.cloudnet.com (apollo.cloudnet.com [209.188.96.28]) by svr1.postgresql.org (Postfix) with ESMTP id 39510D9891 for ; Fri, 14 Oct 2005 15:06:31 -0300 (ADT) Received: from apollo.cloudnet.com (localhost.cloudnet.com [127.0.0.1]) by apollo.cloudnet.com (Postfix) with ESMTP id DEF00D6E87B for ; Fri, 14 Oct 2005 13:06:31 -0500 (CDT) Received: from devbox (meetinggrounds.com [209.188.103.253]) by apollo.cloudnet.com (Postfix) with SMTP id AE683D6E824 for ; Fri, 14 Oct 2005 13:06:31 -0500 (CDT) From: Tyler Kellen To: X-Mailer: PocoMail 3.4 (2130) - Licensed Version X-URL: http://www.sleekcode.net Reply-To: tyler@sleekcode.net Date: Fri, 14 Oct 2005 13:06:36 -0500 Message-ID: <2005101413636.821147@devbox> Subject: FULL OUTER JOIN Question (mistake) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="77312572-POCO-02208632" X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/171 X-Sequence-Number: 23024 This is a multipart message in MIME format --77312572-POCO-02208632 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The first query under 'BAD RESULT:' doesn't have anything to do with my= question Please disregard it! mg=3D# select * from trans_item where id=3D20116; =A0=A0id =A0=A0| trans_id | parent | qty | item_sku | item_price | item_tax -------+----------+--------+-----+----------+------------+---------- =A020116 | =A0=A0=A011216 | =A020115 | =A0=A01 | 91400 =A0=A0=A0| =A0=A0=A0=A0=A0=A00.50 | =A0=A00.0700 (1 row) ^ that Best, Tyler Kellen --77312572-POCO-02208632 Content-Type: text/html Content-Transfer-Encoding: Quoted-Printable
The first query under 'BAD= RESULT:' doesn't have anything to do with my question
Please disregard= it!
 
mg=3D# select * from= trans_item where id=3D20116;
=A0=A0id =A0=A0| trans_id |= parent | qty | item_sku | item_price | item_tax
-------+----------+--------+-= ----+----------+------------+----------
=A020116 | =A0=A0=A011216 |= =A020115 | =A0=A01 | 91400 =A0=A0=A0| =A0=A0=A0=A0=A0=A00.50 | =A0=A00.0700
(1= row)
 
^= that
 
Best,
Tyler= Kellen
--77312572-POCO-02208632--