|Subject||RE: [firebird-support] Left outer join with stored procedure|
The correct syntax for JOINing to an SP would be:
left outer join stored_procedure (:DATE1,:DATE2) ON 1 = 1 <--
I have a table regioni with 164 rows (r_id), and also stored procedure which returns some data like (r_id, value).
When I try to use
left outer join stored_procedure (:DATE1,:DATE2)
I only get number 20 rows for the R_ID which is returned by procedure. I cant manage to get all 164 rows from regioni table matched with values from stored_procedure, where value exists.
Can someno help with this ?