Whats the difference between view and joins ?
Printable View
Whats the difference between view and joins ?
a view is a logical or virtual query
a join is when you have more than one table in a query
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.