Skip site navigation (1) Skip section navigation (2)

RE: sql with postgresql beginner

From: Windy Elliott <windye(at)softshare(dot)com>
To: "'radix(at)ihug(dot)com(dot)au'" <radix(at)ihug(dot)com(dot)au>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: RE: sql with postgresql beginner
Date: 2000-08-30 22:25:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I am a begginer as well, but I am under the impression that you actually
need to join the tables.

select list.item, vendors.vendorname from list LEFT JOIN vendors ON
list.vendorcode = vendors.vendorcode where list.vendorcode = 101;

This is how I would do it.  If I am wrong, please, someone correct me.


-----Original Message-----
From: radix(at)ihug(dot)com(dot)au [mailto:radix(at)ihug(dot)com(dot)au]
Sent: Wednesday, August 30, 2000 3:19 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] sql with postgresql beginner

Could somebody comment on why my SQL query hasn't produced the desired
result (apart from pointing out that my SQL skills suck)

I've listed the two tables I'm using (created them from an example
article at and the select statement which
isn't producing the correct result.

list table
    item     | vendorcode | quantity
 Root Beer   |        100 |        3
 Ice Cream   |        100 |        1
 Napkins     |        101 |       50
 Spark Plugs |        102 |        4

vendors table
 vendorcode |        vendorname
        100 | Super Grocer
        101 | Genernal Department Store
        102 | General Auto Parts

Now here's the select statement which I thought should produce just
one row containing "Napkins | Genernal Department Store"

select list.item, vendors.vendorname
     from list, vendors
     where list.vendorcode = 101;
  item   |        vendorname
 Napkins | Super Grocer
 Napkins | Genernal Department Store
 Napkins | General Auto Parts


pgsql-novice by date

Next:From: JohnDate: 2000-08-30 22:44:18
Subject: Re: sql with postgresql beginner
Previous:From: radixDate: 2000-08-30 22:18:30
Subject: sql with postgresql beginner

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group