Re: sql with postgresql beginner

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
>
>