SQL

Question

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..?

Hemant Srivastava · Answer

Here is it: 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 kumar · Answer

Thanks A lot hemant...