Hi, ehem, I have to withdraw the post below :) The sql query is ok. it works in my local installation. the problem was caused by some typo bugs. I will report on it later.
Nice work Emir !!!! Elpidio On Wednesday 08 December 2004 21:58, Elpidio Latorilla wrote: > Hi Emir, > > it looks like you are using the mysql 4.1 version because of your use of > cascaded "select" in your query. Earlier versions of mysql do not support > this. I cannot run the script because of my older mysql version. > > Well, looking at the query, it looks like it can be rewritten to one using > only normal joins. > > Let me see.... > > Elpidio ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers
