Whats the difference between view and joins ?

[Mary_Itohan]

Whats the difference between view and joins ?

[r937]

a view is a logical or virtual query

a join is when you have more than one table in a query

[fredmintah]

Join is when two or more tables are involved in a query where the join keyword exists.
View are virtual tables created with sql code. NB: Views are not real sql objects and for that matter they are not stored in the database.