Posts Tagged ‘SQL’

JOINs in UPDATE statements, Awesome!

Tuesday, October 14th, 2008

Another post for the developers.

This whole post may be a result of me learning to write SQL queries in Oracle. But I found yesterday that in MySQL you can write an UPDATE statement that includes a JOIN. This was always off limits in Oracle. This means that you can update two tables [...]