Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count if not in another table

Hi,   I have an SQL DB with 2 tables, Staff & Pay.   There is a Many  to one rel-ship based on Staff ID column.   A staff is active or inactive based on their start & end date. If end date is b...