Re: Sql DB2

"Stefan M. Mihokovic" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> Hallo Teresa,
> 
> 
> 
> I am me not sure that I understand yours question correctly.
> 
> An example in more detail would be helpful.
> 
> But I believe this could solve your problem.
> 
> 
> 
> 
> 
>    select TableA_1.field1
> 
>         , TableA_1.field2
> 
>         , TableA_2.field3
> 
>         , TableA_1.field4
> 
>      from TableB
> 
>     inner join
> 
>           TableA as TableA_1
> 
>        on TableB.field2 = TableA_1.field2
> 
>     inner join
> 
>           TableA as TableA_2
> 
>        on TableA_1.field4 = TableA_2.field1
> 
> ;
> 
> 
> 
> 
> 
> Regards Stefan
> 
> ----------------------------------
> Stefan M. Mihokovic
> email:    [EMAIL PROTECTED]
> ----------------------------------


APPRECIATED EVERYONE'S RESPONSE.

TERESA