Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
group by comma separated value
Ganesh M
Aug 22 2014 2:20 AM
801
Reply
i have tow tables. one is Feature table and another one is Property table
The feature table contain following feilds and data
feauture id is primary key
Featureid
Type
1
Garden
2
Parking
3
Swimming pool
4
Balconys
And property table contains data like below
Propertyid is primary key
Propertyid Feature
1 1,2,4
2 3,4
3 1,3,4
4 2,3,4
5 1,4
i want property count feature wise
like below
Feature PropertyCount
Garden 3
Parking 2
Swimming pool 3
Balconys 5
How to join these two tables and property count group by feature Type
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Calling a stored procedure from c# method
I want to dsiplay the Details from table to single line str