General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
A client wants to generate a summary report containing one line per Job.
Here's the file setup (using SBT-type files, but that's not important now):
PAPROJ - one entry per Job; contains Job Description info.
PAMAST - one entry per Job/Phase/Category; contains budget info for each
Job/Phase/Category.
PATRAN - (potentially) multiple entries per Job/Phase/Category; contains
transaction (actual cost) info.
The report output would be:
Job #, Description, Budget Total (from PAMAST, with multiple records per Job), and Actual Tran Total (from PATRAN, with multiple records per PAMAST record).
Optimally, someone could suggest a way for me to do this with FoxFire, but if the answer comes in the form of a query, I'd be just as appreciative.
TIA,
Mark
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only