Table cross joining problem

From: <vidhidwivedi_at_gmail.com>
Date: 21 Feb 2007 21:50:35 -0800
Message-ID: <1172123435.045097.173700_at_q2g2000cwa.googlegroups.com>

[Quoted] Hi everyone i m facing a problem while constructing a query involving two table for gathering dataset.

Table:

	t1(dataset number, target varchar2);
	t2(val number);

below is a sub query which causes problem,

                select DECODE(TRUNC((dataset/3391.52)),0,0,1) from t1

order by 1

here "3391.52" is one of value present in t2 table; same way for all the values present in t2 we need to run same query but if i put t2 in from clause due to no relation between t1 & t2 tables the resultant cross join consists of a very large dataset. Please revert if any solution available.

Thanks
vidhi Received on Thu Feb 22 2007 - 06:50:35 CET