1 2 3 4 5 6
SELECT * FROM nexus_stores.cashier_shifts AS s FULL JOIN nexus_stores.cashier_shifts as c ON s.id = c.id WHERE s.employee_id IS NOT NULL AND s.store_id IS NOT NULL