2007 Oct 19 1:22 PM
Can you please tell me what is the difference between table and generated view?
Nice day Saso
2007 Oct 19 1:32 PM
table can hold records but view is only meant for display .
view can be from one table or from combination of multiple .
Thanxx
If you need certain fields of the table or combination of fields from more than one table or entries from one table such that those entries exist in another table, u can use databse view.
This will work simply as a select query on the database,
2007 Oct 19 1:23 PM
The view may only allow certain fields of the table to be displayed. Or, the view can also join other fields from other tables.
2007 Oct 19 1:32 PM
table can hold records but view is only meant for display .
view can be from one table or from combination of multiple .
Thanxx
2007 Oct 19 1:33 PM
If you need certain fields of the table or combination of fields from more than one table or entries from one table such that those entries exist in another table, u can use databse view.
This will work simply as a select query on the database,
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |