Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-18 : 12:00:32
|
| Fazal writes "Hello sir,I have a problem in retrieving data, Actually our's is a real estate site consist of database of properties listed by individual owners as well as builders. In the case of builders they will have lots of similar units (like 200 units). If somebody search for the property of similar type just think that there are 230 match of which 200 units are listed by builders and all are same where as 30 properties are listed by individual owners. I want to show up all the 30 properties of individual owners and only 3 0r 4 properties of the builders rather than 200 since other will be same. but I want to show tab here saying that lots of options are available in this project.ThanxFAZAL" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-18 : 12:51:14
|
select distinct * from propertiestable where unitlisted = 'builder'union allselect * from propertiestable where unitlisted = 'indivdual owner'If you want any more then that, you'll have to give us your table create statements and explain what you want the select statement to return.As for the tab part, that needs to be done in the webpage itself... SQL can't really return a tab  -----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
request for help on Query