ON clause in mysql query

Question

I use this following query ,it works fine,but i have doubt about why we use 'ON' in this

select * from test_table 
left outer join  test_table_1 on  test_table.id = test_table_1.ref_id

look here : http://dev.mysql.com/doc/refman/5.0/en/join.html — Nicole Stutz, Jul 12 '13 at 08:54

score 0 · Answer 1 · answered Jul 12 '13 at 08:55

0

There shouldnt be any doubt, 'on' is the syntax used to express the join predicate.

answered Jul 12 '13 at 08:55

Andrew

score 0 · Answer 2 · answered Jul 12 '13 at 08:55

0

ON clause describe the relation between those two tables. This is the base of the join (on which fieldd you want to join the tables.)

answered Jul 12 '13 at 08:55

Himanshu

2 Answers2