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 bkrike 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
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
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...
