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 - 2000-09-18 : 08:26:00
|
Cesar C writes "OS = win98
server OS = NT4 with service pack 4 and 5
how do you display three-level nested data from four tables in an access database?
tables w/the relevant fields are as follows:
table A : page_id
table B : section_id,page_id,page_name,project_id
table C : section_id, section_name, project_id
table D : project_id, project_name
I'll be coming from table A to table D
I was able to pull out the data using inner joins; but my problem is I cannot display them properly nested
Desired OUTPUT!!!!
Project Name
......Section Name
.........Page Name
......Section Name
.........Page Name
.........Page Name
Project Name
......Section Name
.........Page Name
.............etc..........
ACTUAL OUTPUT!!!!
Proj name
.....section name
.........page name
proj name
.........secton name
.........page name
there is duplication of levels(project name and section name), is there a workaround for this?
Thank you very much" |
|
|
|
|
|
Trees