Re: SQL Query Help, please?

From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: Fri, 23 Oct 1998 15:35:12 +0200
Message-ID: <36308610.2AD5@pcm.bosch.de>

Hi James.

I'm not sure if i understood you're problem. It seems to me that you want the following:

select table_a.*, table_b.ProtParmAlphaValue
  from table_a, table_b
 where table_b.prot_id (+)	 = table_a.prot_id
   and table_b.DictTableCode (+) = 1010;

HTH Angelito.

James Petts wrote:
>
> I have two tables (call them Table_A and Table_B for originality :-)
> Table_A is the parent, and Table_B the child. Table_B has a foreign
> key column ProtId referencing ProtId in Table_A.
>
Received on Fri Oct 23 1998 - 08:35:12 CDT