LEFT OUTER JOIN?

From: Peter Landis <ntwebdeveloper(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: LEFT OUTER JOIN?
Date: 2000-05-24 21:13:34
Message-ID: 20000524211334.25505.qmail@web3205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi- I'm a newbie at postgres but have a pretty good
understanding of SQL statements. I have created two
views and wanted to do a LEFT OUTER JOIN of the two
tables. The sytax is

select * from vcompany LEFT OUTER JOIN ON
vcompany.id=vregistry.id;

I get the following error:
LEFT OUTER JOIN not yet implemented

My question is does postgresql 6.5 support Left out
join and if not is there another way of implementing
this sql statement to give me a LEFT OUTER JOIN.

The logic if very simple. Look below to see the
tables:

vcompany
+--------+---------------+
| id | Name |
+-------+----------------+
| 1 | Peter |
| 2 | John |
| 3 | Joe |
| 4 | Jerry |
| 5 | Mike |
+--------+---------------+

vcompany
+--------+-------------+
| id | Desc|
+-------+--------------+
| 1 | A |
| 2 | B |
| 5 | D |
+--------+-------------+

JOIN OF THE TWO

+--------+---------------+-------------+
| id | Name | Desc |
+-------+----------------+-------------+
| 1 | Peter | A |
| 2 | John | B |
| 3 | Joe | |
| 4 | Jerry | |
| 5 | Mike | D |
+--------+---------------+-------------+

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2000-05-24 21:30:18 Re: LEFT OUTER JOIN?
Previous Message Bryan White 2000-05-24 21:09:45 PG 7.0 is 2.5 times slower running a big report