Left Join Queries - Mailing list pgsql-general

From Derricutt, Mark
Subject Left Join Queries
Date
Msg-id 93314B6256A5D211BE8B006097B9502717912B@NZAM
Whole thread Raw
List pgsql-general
Hi, I was just wondering if PostgreSQL supports left join queries yet?  Or
if not, if its on the cards to the next release?

I'm in the process of porting an application from Paradox to use several
database servers, and was surprised to read in some older posts (from the
web-archive) that PostgreSQL didn't do left joins.

One of the queries I'm doing is as follows (rather simple as well):

    SELECT a.CrossID, a.Name, a.LandScape, COUNT(b.CrossID) AS countfld
    FROM ctabhed a LEFT JOIN ctabdat b ON a.CrossID = b.CrossID
    GROUP BY a.CrossID, a.Name, a.LandScape

This just returns the header data, and the count of the detail in one table.

Mark

--
Mark Derricutt
Now Playing: Roine Stolt - The flower king



pgsql-general by date:

Previous
From: affiliate1@www.theinternetdirectory.net
Date:
Subject: The Internet Directories
Next
From: Lincoln Yeoh
Date:
Subject: Re: [GENERAL] Oft Ask: How to contribute to PostgreSQL?