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 |
|
muratcan1
Starting Member
3 Posts |
 Posted - 2007-06-19 : 03:41:29
|
| Hello, i have a titles and topics table. i want to get data like :title_id----title_name---topic_name--topic_title_id1-----------title1-------null--------nullnull--------null---------topic-------1null--------null---------topic-------1 2-----------title2-------null--------nullnull--------null---------topic-------2is that possible? if not how can do it in an effective way?i need to list them on my page group by groupPlease help.Thank you |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-19 : 04:02:48
|
Can you post your table structure with sample data and the corresponding result that you want ?
KH |
 |
|
|
muratcan1
Starting Member
3 Posts |
Posted - 2007-06-19 : 04:09:29
|
| there are some topics under titles for exampletitles tabletitle_id title_name1 Internet2 Programmingtopics tabletopic_id--topic_name topic_title_id1---------TCP/IP----------------12---------Network Communication-13---------Internet History------14---------Visual Basic----------25---------Tips/good programming-2In fact, I need to list them on the page like that:title1-its topics-its topics-its topicstitle2-its topics-its topics-its topicsI wonder can be done with one query?Thank you. |
|
|
|
muratcan1
Starting Member
3 Posts |
Posted - 2007-06-19 : 04:51:44
|
| please help, i really need.thanks a lot |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
How can be written that query?