linking multiple table and getting values,
May 4, 2007 at 1:06 PM
I have tables like =>Country_Master Country_Id Name =>State_Master State_Id State_Name Country_Id =>Town_Master Town_Id Town_Name State_Id
Like this many hierarchy.
I want to know how i will get the selected fields from table. SQL: select Name,State_Name,Town_Name from Country_Master C,State_Master S, Town_Master T where S.Country_Id=C.Country_Id and T.State_Id=S.State_Id