Question

write difference between table and query

this is the question of sub-computer
​

Answer 1

Answer:

A table is a set of rows that holds data that can be updated and the results are permanent. A query is a “on the fly” results or sub set of data that only exists in memory and is discarded after you use the results. So for general reporting and display of data, it makes no sense to create a temp table.

Answer 2

Data is not physically stored in a query whereas a table is the physical data archive. ... In a query, you can bring fields from more than one table together for a query linking them into a relationship and therefore create more flexible reports.

ANY OTHER HELP

SAHIL HERE