From: | Maximilian Tyrtania <Mty(at)Fischerappelt(dot)de> |
---|---|
To: | pgsql-novice-Regel <pgsql-novice(at)postgresql(dot)org> |
Subject: | Need smart sql |
Date: | 2004-01-06 15:46:44 |
Message-ID: | BC2096F4.23AC5%Mty@Fischerappelt.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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'.
Anyone?
-> Maximilian Tyrtania | Mty(at)fischerAppelt(dot)de
fischerAppelt Kommunikation GmbH
Tucholskystr. 18 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de
--
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-01-06 16:49:07 | Re: Need smart sql |
Previous Message | Martin Hampl | 2004-01-06 11:37:34 | Disk usage |