how to write left-right join and multiple update query in PHP

how to construct left-right j开发者_运维问答oin and multiple update query in PHP ?

The SQL will not change - your left joins and multiple updates look the same, whether you're writing them as part of a PHP, C# or any other program. If you're looking to learn how to do a left join, look for general SQL tutorials on Google (or maybe ones that are specific to the database you're using).

If you're looking for a generic tutorial for writing SQL inside of php, look here:

http://www.freewebmasterhelp.com/tutorials/phpmysql/4

Specific examples of SQL queries inside of PHP are frequent, here's a left join example:

http://www.roseindia.net/sql/sqljoin/leftJoin.shtml