why I am getting this error ?
ERROR: 42703: column "8c6984fc-5e7e-41cd-9f4c-3bc0c56eaebc" does not exist
LINE 21: WHERE u.id = "8c6984fc-5e7e-41cd-9f4c-3bc0c56eaebc" AND u.tenant_id = "f997ca0e-9bed-4550-a115-1175ff1406e7"
Here is my sql code:
SELECT
u.id,
u.email,
u.password,
u.firstname,
u.lastname,
u.whatsapp,
u.phone,
u.city,
u.street,
u.zipcode,
u.nationality,
u.paid,
u.sex,
u.tenant_id,
u.worker_id,
et.name as employement_type
FROM users u
LEFT JOIN employement_types et
ON et.id = u.e_types_id
WHERE u.id = "8c6984fc-5e7e-41cd-9f4c-3bc0c56eaebc" AND u.tenant_id = "f997ca0e-9bed-4550-a115-1175ff1406e7"
LIMIT 1;
I dont see any problems with that code I only make two conditions at where