Hello All, 

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 

select 

regioni _ID, 
stored_procedure_value

from regioni
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 ?

Regards,

Zoran  
 

  • ... zilez2...@yahoo.com [firebird-support]
    • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
    • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
      • ... t...@camalot.ca [firebird-support]

Reply via email to