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 On Wednesday 08 December 2004 10:07, Emir Prcic wrote: > Hi, > as I promised (long time ago), here is the change to the tree menu. Now it > should be displaying wards grouped in departments. ------------------------------------------------------- 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

