Complex SQL Statements

[Steve Dyke]

I have a report using jasperreports(itext)

Is there any way to have a function in the SQL statement as a column and have that function run a seperate SQL statement?

Somthing like "Select f1, myfunction(f1) As f2 From mytable"

[Rob Spoor]

I have done similar things quite often:

SELECT somefield, (SELECT MAX(otherfield) FROM othertable WHERE othertable.x = thistable.y) AS max_otherfield FROM thistable

Of course this function can have only a single row in the result set.

Moving to the JDBC forum.

[Jan Cumps]

What is your database? Oracle has stored functions that can be used in queries.