Sql Query

[sanu]

i have problem in sql query please help me out this eating my brain
i have a table like below
table1
cid | mod
1 2
2 1
3 2

table2
sid | uid | cid
1 4 1
2 5 2
3 4 2
4 5 3

table3
con_id |sid
1 1
2 1
3 3
4 2
5 1
6 3

now i want to find out "mod" and "uid" from "con_id"
first find "sid" from "con_id" and and from "sid" ,"uid" and from "sid" ,"cid and "mod"
but i am confuse with sql command

[khaldryck]

select table1.mod, table2.uid
from table1 inner join table2 on table1.cid=table2.cid
inner join table3 on table3.sid=table2.sid
where table3.con_id='".$con_id."'";

just that easy 😉

it will gives you exactly what you want in a single query.

[sanu]

thanks for your help it worked
i am familiar with joining two table but had not played with three tables , i am lil poor in sql command ,thanks anyway