I know that's a very open-ended question, but I started this project with the intent of using MySQL.
However, I now realize that my servlets will be running twice a many queries as expected because MySQL doesn't support subqueries or joins on update queries, such as: update tbl_shift inner join tbl_team on tbl_shift.shift_id = tbl_team.shift_id set tbl_shift.employees = tbl_team.team_size Of course, with enough money I could buy a full ANSI DBMS and solve the problem, but the price of MySQL is so attractive. Has anyone else run into this problem and found a good solution? TIA, Scott ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
