SELECT s.id,checkout_id,employee_id,s.store_id AS shift_store_id,c.store_id AS checkout_store_id,start_timestamp,end_timestamp
FROM nexus_stores.cashier_shifts AS s
INNER JOIN nexus_stores.checkouts AS c
ON c.id = s.checkout_id