Sql problem( select statement)

From: Abiy Alemu <abiy_at_biotec.jouy.inra.fr>
Date: 1997/07/23
Message-ID: <Pine.SOL.3.91.970723170642.19198A-100000@biotec>#1/1

Is it possible to have on one row, values from father and son tables(dept and emp tables for ex.)

Example

col1		col2		col3		col4  	   col5
Accounting	king		clark		miller
Research	Blake		Ford		Smith	   Adams

... and so on

where Accounting and Research are from the DEPT table and the remaining values are from EMP table.

Thank you

|-----------------------------------------------------------------------------|


| If the only tool you have is a        | Abiy Alemu abiy_at_biotec.jouy.inra.fr |

| hammer, everything in the world       | 9, avenue calmels                   |

| seems like a nail.____________________| 92270 Bois colombes (France)________|

Received on Wed Jul 23 1997 - 00:00:00 CDT