Difference between reports and queries?

pushVTECpushVTEC
edited January 2004 in Internet & Media
I'm in CSA 385, and I can't for the life of me come up with the difference betwen reports and queries. Best explanation I can think of is a query takes a table and given the criteria entered into it it displays the results that meet that search. While a report just spits out a table in the database. The question also wants to know what SQL commands would be used to execute a query and which would be used for a report? Thanks!

Right now i'm thinking the report would use select, and the query would use where.

Comments

  • EnverexEnverex Worcester, UK Icrontian
    edited January 2004
    This is just a guess, but can't a Query actually perform actions and change things, where as a report just gives back information without changing anything?
  • MediaManMediaMan Powered by loose parts.
    edited January 2004
    As far as I understand it a query is a question and a report is a presenter. A query or set of queries are needed to generate a report. You must ask the question and get raw data (query) to be able to present the data. (report)

    If I've got that correct. In this case the egg must come before the chicken.
Sign In or Register to comment.