MySQL: Federated query

SELECT T1.name, t2.salary from employee as T1 INNER JOIN info as t2 on t1.name = T2.name; You can use aliases for data tables

Select T1.id,t2.id
from T1
Left JOIN T2 on t1.id = T2.id and t1.id>1 and t2.id<>3

Http://wenku.baidu.com/link?url=r-ks3kd0ZtGJtLW9vKq_ B7kaejtugvpacv1nmitceshi1djwip50p44r6ck076bdfyykw1caikppylp5ywymplgoqp25qhjn2a0skhyhkle

In the left join of MySQL the condition is placed behind and is different in the back of the Where;

1. On the back only for the T2 table filter, so the above t1.id>1 will not work, remember, remember;

2. Where the end result has an effect, so if the t2.id<>3 is placed behind the on and the where behind will return different results;

For example, the following script will return some data more than script two.

Http://database.51cto.com/art/201011/234480.htm

SELECT * FROM Test2
Left join test1 on test2.id = Test1.id and test1.id<>3
where Test2.id <>6;
SELECT * FROM Test2
Left join test1 on test2.id = test1.id
where Test2.id <>6 and test1.id<>3;

MySQL: Federated query