How Mysql join query on three tables with multiple colums?

Question

I have three tables like this:

Table1

english | hindi
--------------
 shakti  | शक्ति
 sharma  | शर्मा

Table2

eng| hin
------------------
 Jai |जय  
 Jo  | जो

**Table3*

name | commo| price  |
----------------------------------
 shakti  | jai  | 123.00 
 sharma  |jo  | 224.00 
 anil | paddy  | 1286.098

**I want to get result something like this*

 hindi| hin | price 
    --------------------------
     शर्मा    |   जो | | 224.00

Description :
there is no primary key in any table I want all records where
**Table2* = 'जो'

I tried but I am not able to fetch the data correctly. Please help.

It appears you are using English names/terms as keys. Why not use numeric (integer) values instead? That would likely make your keys shorter. — Andriy M, Apr 14 '14 at 06:16
`jo` corresponds to `sharma` then how can you get `shakti` in ouput — G one, Apr 14 '14 at 06:20
@G one u r right by mistaken i wrote there shakti it shoud be sharma — user3493831, Apr 14 '14 at 06:22

score 0 · Answer 1 · answered Apr 14 '14 at 06:19

0

There Must be a primary key and foreign key concept in table. Give Primary key in all table and give relation using foreign key.

I think you get the point.

answered Apr 14 '14 at 06:19

Jatin

score 0 · Accepted Answer · answered Apr 14 '14 at 06:24

0

Its a simple inner join statement

select t1.hindi, t2.hin, t3.price
from table1 t1 inner join table3 t3 on t1.english=t3.name
inner join table2 t2 on t2.eng=t3.commo
where t2.hin='जो'

answered Apr 14 '14 at 06:24

G one

2 Answers2