subselect sql查询不适用于mysql 4

本文介绍了subselect sql查询不适用于mysql 4的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

以下sql查询在运行mysql 5的开发服务器上正常运行，但是当我在运行mysql 4的实时服务器上尝试运行它时，会抛出错误，有人可以帮助我说明如何使查询适应于mysql 4上运行吗?

The following sql query works fine on my development server running mysql 5, but when I try it on my live server running mysql 4 it throws an error, can anyone help show me how to adapt my query to run on mysql 4?

select * FROM Properties WHERE propertyid IN (select id from todelete)

推荐答案

SELECT * FROM Properties RIGHT JOIN todelete ON (Properties.propertyid = todelete.id);

要从符合此条件的属性中删除所有行，请使用以下方法:

To delete all rows from Properties which match this condition use this:

DELETE Properties FROM Properties INNER JOIN todelete ON (Properties.propertyid = todelete.id);

请参见 T-SQL:选择要通过联接删除的行