Hi im trying to make a query using sub selects, but this feature is not supported in my mysql version. what im trying to do is to get all the records that appears in one table but not in the other table. im doing something like this:
problema.no_problema NOT IN (
WHERE calif.n_control = '03040925'
In my local machine it works, i have the latest version of mysql, but in the server its not working and im not able to update the version.
I hope you can tell me a different solution to do this query