Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by pet ( 13 years ago )
select LH_CREDIT_PRODUCT.first_portion_remission_flag "+
"from LH_BUSINESS_CASE, LH_CREDIT_PRODUCT, (select MAX(LH_CREDIT_PRODUCT.version) as ver "+
"from LH_BUSINESS_CASE, LH_CREDIT_PRODUCT "+
"where LH_CREDIT_PRODUCT.business_case_fk = LH_BUSINESS_CASE.business_case_pk "+
"and LH_BUSINESS_CASE.business_case_id = ?) "+
"where LH_CREDIT_PRODUCT.business_case_fk = LH_BUSINESS_CASE.business_case_pk "+
"and LH_CREDIT_PRODUCT.version = ver "+
"and LH_BUSINESS_CASE.business_case_id = ?
Revise this Paste