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 - 2001-11-19 : 23:00:33
|
| John writes "I'm Fairly new at using ASP / SQL so please pardon the possible simplicity of this question. I am trying to develop a one to many relationship from one table to the next. Without going into detail about this particular exersise I think it will be easier to explain what I am looking for by using a call log as an example. I am trying to display (in the best way possible), for example a person's name and then all the related calls assosiated with them. For instance, John Doe, the date of call and the details, Next date, call details ect... Currently I pull information from a table using a filter and then open the next table and use another filter. This causes information to be displayed in unpredictable manners. I am looking for a, maybe a Join, or someother single SQL output that will give me better results.Can you help?John" |
|
|
|
|
|
SQL and Display