From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Maximilian Tyrtania <Mty(at)Fischerappelt(dot)de> |
Cc: | pgsql-novice-Regel <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Need smart sql |
Date: | 2004-01-06 16:49:07 |
Message-ID: | 20040106164907.GA12608@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Jan 06, 2004 at 16:46:44 +0100,
Maximilian Tyrtania <Mty(at)Fischerappelt(dot)de> wrote:
> Folks,
>
> I'm in need of a little pointer on how to do the following:
>
> I have a company-table and an employee-table. The employee-table has a
> company_id field and a birthday-field. Each company-record may relate to no
> or some employee records. Nothing too exotic so far, I guess.
>
> Now I want to select all the company-records names and along with the oldest
> employee's name. Or, if there is no employee, I want to display something
> like 'no employees'.
One approach would be:
select companyname, coallesce(
(select employeename from employees where employees.company_id =
company.company_id order by birthday limit 1), 'no employees')
from company
From | Date | Subject | |
---|---|---|---|
Next Message | Rory Campbell-Lange | 2004-01-06 17:51:18 | Integrity problem on 7.3.4 |
Previous Message | Maximilian Tyrtania | 2004-01-06 15:46:44 | Need smart sql |