I just got it with
select list.item, vendors.vendorname
from list, vendors
where list.vendorcode = 101 and vendors.vendorcode = 101;
I thought that the 'from' clause was a join?
Back to the docs for me I think.
----- Original Message -----
From: Windy Elliott <windye@softshare.com>
To: <radix@ihug.com.au>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, August 31, 2000 7:55 AM
Subject: RE: [NOVICE] sql with postgresql beginner
> 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.
>
> Windy
>
> -----Original Message-----
> From: radix@ihug.com.au [mailto:radix@ihug.com.au]
> Sent: Wednesday, August 30, 2000 3:19 PM
> To: pgsql-novice@postgresql.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 www.networkcomputing.com) 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
>
>