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
