I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips can be processed for
each employee for each period.
The problem lays where I would like to display a list of employees that
don't have transactions
When checking for unmatched records, you use a left join as you are
doing. This assures all records are retained from the left side table
(i.e. employees), regardless if there is a matching record or not.
Obviously if you have a filter on the left side table it will narrow
down the result.
Get those with transaction into a php array
Get those without transaction into a php array
Then use array_diff() (or one of its variants)
graeme.
jinxed wrote:
I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips