>> I have a table called Jobs and another called Applications.
>> I can query all Job rows, but how do I also include the number
>> of Application rows for each Job row in the SELECT statement?
Try this way:
(1) CREATE VIEW viewappl AS
,count(*) as numappl
FROM job , viewappl
where job.jobid = viewappl.jobid
I hope it's ok.
pgsql-php by date
|Next:||From: Nick Barr||Date: 2004-01-15 08:37:40|
|Subject: Re: Selecting from two tables|
|Previous:||From: Michael Hanna||Date: 2004-01-14 23:33:13|
|Subject: Selecting from two tables|