Jump to content

Archived

This topic is now archived and is closed to further replies.

ryland22

MySql syntax error

Recommended Posts

If I write \"SELECT cust_id FROM table1 WHERE table1.cust_id IN (1203)\" I have no problems.

 

If I write \"SELECT cust_id FROM table1 WHERE table1.cust_id IN (SELECT cust_id FROM table2)\" I receive a Sql syntax error. What am I doing wrong?

Share this post


Link to post
Share on other sites

Yes, after some searching I found that only Mysql version 4+ will allow subqueries and my webhost is running Mysql 3+.

Share this post


Link to post
Share on other sites

Specifically in MySQL version 4.1, which is in alpha testing right now, you will be able to do subqueries.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.