Re: SQL query problem

From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: 1998/02/27
Message-ID: <34F66D21.1939@pcm.bosch.de>#1/1

Hi Bob.

It seems to me that u are searching for this:

Select tab_1.field_1, tab_1.field_2

  from table_1 tab_1, table_2 tab_2a, table_2 tab_2b
 where tab_2a.field_1 = tab_1.field_1
   and tab_2b.field_1 = tab_1.field_2

 order by tab_2a.field_2+tab_2b.field_2;

HTH Greez,
Angelo.

Bob McConnell wrote:
>
> I am trying to resolve the following query problem:
>

-- 
-----------------------------------------------------------------
Angelo Cavallaro     /  /  /   \     TECTUM Beratungsgesellschaft
ORACLE-SW-Berater   /  /  /     \    für Informationsverarbeitung
ancavall.NOSPAM    /  /  /-------\   Tel: 0711/99073-10
@aol.com          /__/__/_________\  Fax: 0711/99073-99

-----------------------------------------------------------------
	 Visit the Home of the Green Ribbon Campaign:

		http://www.ponce.oisoft.com/

-----------------------------------------------------------------

Received on Fri Feb 27 1998 - 00:00:00 CST