few days back i attended one interview. he asked write a query for get the results from these tables.
there are two tables. one is for 'USER' and another is 'Properties'.
in the user table there is 3 feilds user_id,name and subscription_id.
in properties page property_id and user_id.
here is the table structure:
user_id(primary), name, Subscription_id
1 , test , 3
2 , test1, 2
3 , test2 , 3
4 , test3 , 1
property_id(primary) , property_type, user_id(foreign)
1 , villa, 2
2 , home, 4
3 , land 1
4 , home, 2
5 , home, 3
6 , land, 3
7 , villa, 1
8 , home, 4
now i am searching 'home' using search form. then i have to display all the results which property type
is home in the order of subscription_id.
here now i have retrive properties in the order of subscription_id.
anybody tell how to retrive now. i am fully confused with this.