Count(*) for field.a <<condition>> field.b

rbuser

Hi,

How can I to make a following Sql:

SELECT COUNT(*) FROM A WHERE A.DATA_X >= A.DATA_Y

- when I put in filter condition a value A.DATA_Y don't is seen with a field
of table.

I'm use Rbuilder 7.03, ORACLE 9i.


Thanks,

Smokoveck

nicocizik

Hi Smokoveck,

In my testing with the latest version of ReportBuilder, I am able to create
a SQL statement similar to the one below by simply adding the
table.fieldname to the Value edit box in the search tab of the query
designer.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com