Avast WEBforum

Other => General Topics => Topic started by: krypton on December 11, 2014, 11:19:07 AM

Title: mysql syntax help
Post by: krypton on December 11, 2014, 11:19:07 AM

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.

Title: Re: mysql syntax help
Post by: Eddy on December 11, 2014, 06:25:31 PM

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