Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Apache + Tomcat set-up problem
Win2K, Apache 2.0.47, Tomcat 4.1.27 Having tried various tutorials I finally found one that worked .. http://www.greenfieldresearch.ca/technical/jk2_config.html So I've got Apache and Tomcat running; localhost resolves to Apache's default homepage, while localhost:8080 shows Tomcat's. And when...- grimep
- Thread
- Replies: 1
- Forum: General e-Business discussion
-
update with a select on 2 tables
ah right, I had read some of its limitations in the manual. Sorry, hadn't noticed a mySQL forum here - though the answers I've received have been really helpful, I did a relational databases course 3 years ago, SQL was one module out of several. The SQL part covered most of it but was fairly... -
update with a select on 2 tables
neither solution works in mySQL. in the original style.. UPDATE table1 SET table1.val = table1.val - 1 works, but as soon as you introduce a 2nd table it doesnt UPDATE table1, table2 SET table1.val = table1.val - 1 <no joy> Thanks for the help swampboogie, that looks like it... -
update with a select on 2 tables
Is it possible to do an update on one table, with a selection across 2 tables, or does one first have to query a table, then iterate through the rows doing an update on the other table per line (which seems v inefficient)? I want to say something like UPDATE table1, table2 SET table1.val =... -
Trouble formulating tricky query
thanks, I think you've saved my bacon. It looks so simple and obvious when you see it written... I guess one day I'll be thinking in SQL ! -
Trouble formulating tricky query
Am using PHP/MySQL, though that should be fairly irrelevant.. I have two tables and am trying to write a query that does a simple selection on the first table (on thrID), and if there is a corresponding record in the other table and a match on another selected field (userID) indicate that with...
