Hello Guys,

I want to insert data from two tables into a Drop Down List... The situation is like this .. I have two tables named TablePropertyCategory and   TablePropertySubCategory.. As the name signifies sub category table contains the sub-category elements of category table... I want to display the data of both tables like this:

Here ALL Resedential and All commercial is from tablePropertyCategory.. While the remaining are from

Sub-Category table..

Plz suggest how to do this alongwith the SQL -Query.. I am using MS SQL as my database..

Regards and Thanx in Advance