query builder

[avvishnu]

Department_master,staff_assign and staff_master are my 3 tables.
Department_master contain Dpt_Id,
staff_assign contain Dpt_Id and stm_id,
staff_master contain stm_id. By using Dpt_Id i have to get values from staff_master using the table staff_assign. "normalization is used"

[alimadzi]

avvishnu wrote:

Department_master,staff_assign and staff_master are my 3 tables.
Department_master contain Dpt_Id,
staff_assign contain Dpt_Id and stm_id,
staff_master contain stm_id. By using Dpt_Id i have to get values from staff_master using the table staff_assign. "normalization is used"

SELECT sm.*
  FROM staff_master sm
  INNER JOIN staff_assign sa ON sa.stm_id = sm.stm_id
  INNER JOIN Department_master dm ON dm.Dpt_Id = sa.Dpt_Id
  WHERE dm.Dpt_Id = '$something'

Is that what you wanted?