what is the difference between table and generated view

[Former Member]

Can you please tell me what is the difference between table and generated view?

Nice day Saso

[Former Member]

The view may only allow certain fields of the table to be displayed. Or, the view can also join other fields from other tables.

[Former Member]

table can hold records but view is only meant for display .

view can be from one table or from combination of multiple .

Thanxx

[Former Member]

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,