Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select r.id from INTERSHOP.JOURNAL_RECORDS r WHERE r.edit_state = 0 AND r.journal_id = 515 AND r.journal_table_id = 1
- and (SELECT STRING_VALUE FROM journal_field_data f WHERE r.id = f.journal_record_id AND field_name = 'SERTIF_NUMB') = :SERTIF_NUMB
- order by r.PRIMARY_DATE desc;
Add Comment
Please, Sign In to add comment