Sql Subselect Statement Issue In Ireport

I am using iReport to write custom reports and have ran into an issue. I am attempting to alter an existing report by adding the line of code that is: LEFT JOIN (select info from c

Solution 1:

It turns out that the issue was the way I was programming the subQuery.

I was using LEFT JOIN (select info from customfieldview where cftableid = 97022306 and recordid = so.id and cfname = 'SIN')

and saying it was a subQuery when in fact because it was being use in the FROM condition/arguement then it is actually a Derived Table.

I did not know there was a difference!

Thank you guys for the input and helpful tips!