mysql select query problem

[jaiffed]

how can i select multiple fields from multiple table in one query like

 

i have table name t1 and t2

 

t1 fields are f_id,f_name,f_des

 

t2 fields are f_id,ft_name,ft_des

 

i need query which select f_id from both tables and f_name from table t1 where table t2 f_des=1

 

plz help me

[The Little Guy]

Try this:

 

SELECT * FROM t1 LEFT JOIN t2 ON (ft_des = f_des) WHERE f_des = 1 

[jaiffed]

what is left join and its not working

 

and only f_id which are similar in both tables

like f_id from t1 has 101,102,103, 104,105 and f_id from t2 has 101,103,104

now i need ids only 101,103,104 with their f_name from t2

[phobucket]

If you only want records from t1 that have a matching record in t2 then try this:

 

SELECT t1.f_id, t2.f_id, t1.f_name
FROM
   t1 JOIN t2 ON t1.f_id = t2.f_id
WHERE
   t2.f_des = 1;

 

If you want all records from t1 whether or not there is a matching record on t2 with f_des = 1, then try this:

 

SELECT t1.f_id, t2.f_id, t1.f_name
FROM
   t1 LEFT JOIN t2 ON (t1.f_id = t2.f_id AND  t2.f_des = 1);

[jaiffed]

Thanks photobucket

it's working perfectly