Can you please tell what are the exact queries and the syntax that you enter in SQLyog. Also please explain the steps that you follow while writing those queries when the error occurs. Give us some screenshots so that we can look into it.
Thank you for your reply. Please look at the attached pictures. The same SQL query produces an error instead of giving a result when I copy and paste it to SQLyog, but when I copy and paste it to Heidi SQL, it gives a result.