Re: simple sql question

From: Conan Farrell <conan_at_(remove_this)as-if.com>
Date: 22 Oct 1999 12:50:44 +0100
Message-ID: <01bf1c7b$b1f8f020$b501ce0a@Cfarrell.snn.ie.sykes.com>

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>...
> 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
>
>
Received on Fri Oct 22 1999 - 06:50:44 CDT