Thread: Left Join Queries

Left Join Queries

From
"Derricutt, Mark"
Date:
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