i am making payroll software but i m facing some problem when i making salary of employee how can i check that attendance table fill or not

there are many ways for doing this..

but simple way is that..

before you perform any operation of salary you need first fire a select query based on your where criteria and if that select query returns any thing then its confirm you that some thing in attendance table and do what you want with salary or attendance table.....

or is select query is not returning any thing then do what you want...


this is the simple way..
but there is many way as i said at starting try to make PLSql logic in your store procedure or with functions or trigger