RE: How to perform the following Query in MySQL

2003-05-30 Thread Jaime J. Maiz
Hello, No sooner I sent this message I found out that my version of Mysql 4.0.13 for Solaris 8 does not support Subqueries. In addition, I also found that the MINUS concept in my query is a unique operator to my DB engine. Thanks for your support ands sorry to waste your time.   Thanks,

Re: How to perform the following Query in MySQL

2003-05-29 Thread Becoming Digital
MySQL only supports sub-queries as of v4.1. What version are you running now? While I am not terribly familiar with joins, I believe that one, properly executed, could solve your problem. In fact, a similar question was raised earlier today. Search the archives for a post with the subject "Upda