Dear all,
i have a table called sundry_items_re ply on which i am doing a trigger after insert . i have also another table called sundry_items
both tables have a common field called REF
i want my trigger to check after the insert on sundry-items_reply if it has a certain field called recoverd equal to "YES" to go check for the same ref in table sundry-items if this record have a certain field timeout equal to "YES"
if this is the case i want my trigger to make a select on the sundry_items_re ply for some reasons why i can't use select on the same table any things cn be done for this issue?
i have a table called sundry_items_re ply on which i am doing a trigger after insert . i have also another table called sundry_items
both tables have a common field called REF
i want my trigger to check after the insert on sundry-items_reply if it has a certain field called recoverd equal to "YES" to go check for the same ref in table sundry-items if this record have a certain field timeout equal to "YES"
if this is the case i want my trigger to make a select on the sundry_items_re ply for some reasons why i can't use select on the same table any things cn be done for this issue?
Comment