mysql syntax help

[krypton]

hello

i want to join 3 tables with help of inner join in mysql.anybody tell me syntax of it.i tried everything but i facing errors in it

i tried

Code: [Select]

SELECT column_Name1,column_name2,......
  From tbl_name1,tbl_name2,tbl_name3
  where tbl_name1.column_name = tbl_name2.column_name
  and tbl_name2.column_name = tbl_name3.column_name

what mistake in it?

i posted this problem here because avast got excellent coders and designers.so i hope i will get help.

[Eddy]

http://dev.mysql.com/doc/refman/4.1/en/join.html