I have problems with the following query:
INSERT INTO 'pasajeros' ( 'nombre','apellidos','email','password','telefono') VALUES ('Alexandra','Gonzalez','[email protected]','1234567!','04242344556' ) WHERE NOT EXISTS ( SELECT * FROM 'transportistas' WHERE 'email' = '[email protected]');
What do I have wrong with the code? I need to make an Insert only if the email is not used in that other table. Just add the
WHERE NOT EXISTS sentence to the side but apparently I do not comply with the required syntax, how can I improve my code?