Question
April 27, 2007 at 06:58 PM
alex789

Problem with change heading in a self-join table

by alex789 . Updated 19 years, 4 months ago

Hi all and thanks in advance, i’ve got the following table but I need change some of its heading. Could you help me with that please.

Here is the table

TTITLE ‘PHYSICAN SALARY’
SELECT a.phys_name, a.phys_salary, b.phys_name, b.phys_salary
FROM physician a, physician b
WHERE a.phys_supvisor_no = b.phys_ref_no
AND a.phys_salary < b.phys_salary ORDER BY a.phys_name;

This discussion is locked

All Comments