I have two tables
table-1
Proproom_Id PropReg_id PropRoom Name
table-2
Propreg_id propregname
and i have a combobox
how to write a sql query to bind a combobox on the click , propregname hase been binded already on click of propregname proproom name related to that has be bind
how to write sql query for that..?
Loading
Hemant SrivastavaPosted Oct 20, 2012, 1:19 PM
SELECT PropRoom_Name
FROM table-1
INNER JOIN table-2 ON table-2.Propreg_id = table-1.Propreg_id
WHERE table-2.propregname = 'YourComboBoxSelectedItem'
Hope this could help , If not let me know.
If yes, pls make this answer as accepted answer :)
pradeep kumarPosted Oct 22, 2012, 6:13 AM