Re: simple sql question
From: Conan Farrell <"Conan>
Date: 1999/10/22
Message-ID: <01bf1c7b$b1f8f020$b501ce0a_at_Cfarrell.snn.ie.sykes.com>#1/1
;
Hope that helps
Date: 1999/10/22
Message-ID: <01bf1c7b$b1f8f020$b501ce0a_at_Cfarrell.snn.ie.sykes.com>#1/1
try this,
select
b.colx , a.col2, b.coly, c.col2 from tableA a, tableB b, tableA c where b.colx=a.col1 and b.coly=c.col1
;
Hope that helps
-- Conan Farrell Rajkumar Manickavasagam (Raj) <rmnckvsg_at_memphis.edu> wrote in article <6EC14873F507D3119B8C0090273C43490C0A7B_at_jdasoftware.com>...Received on Fri Oct 22 1999 - 00:00:00 CEST
> hi
>
> i have 2 tables A and B. table A has a py key col1 and a description
> field col2. table B has 2 columns....colx references col1 of table A
> and coly references col1 of table A.
>
> i need to get a report that lists as follows;
>
> colx corresponding-col2 coly corresponding-col2
>
> i would prefer it if i could create a view for this. i have spent the
> whole day on this with no luck.
>
> regards,
> raj
>
>