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 - 2005-05-18 : 07:30:20
|
| Mark writes "I have two tables. The first table stores information about programmes and its primary key is the program id number. The second table sores information about changes to the programmes and it primary key fields are the program id number and the revision number. I would like to produce a report which shows all the programmes in table one and the information from table two for the latest(highest number) revison of the programme.How should I go about writing SQL to be used for the Report?If I was writing this is an ASP page I would use two queries but I cant see how to do this in access." |
|
|
|
|
|
SQL - Access