blob: 70a712a31d8e45528df4a8b0b27e3adf97749ed2 (
plain)
1
2
3
4
|
SELECT COUNT(s.*) AS store_id_null_count,COUNT(c.*) AS employee_id_null_count
FROM (SELECT * FROM nexus_stores.cashier_shifts WHERE store_id IS NULL) AS s
FULL JOIN (SELECT * FROM nexus_stores.cashier_shifts WHERE employee_id IS NULL) AS c
ON s.id = c.id
|
