Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006/6/5, MySQL Nexeia <[EMAIL PROTECTED]>: I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works f

Subquery Problem With mysql-4.0 (Works with mysql-5.0)

I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with mysql