+ 2
Join is a command to use in SQL queries. A view is a stored SQL query.
23rd Jun 2016, 4:46 AM
spec - avatar
+ 2
when you use a join it creates a new table. It is an actual table that you can access like the tables you joined together to create it. when you use a view you create a logical one.
29th Jun 2016, 2:15 AM
Kwan H Yee
Kwan H Yee - avatar
Join command joins two or more tables where vie creates a view(a table) with specified columns.
14th Apr 2016, 7:46 PM
shubham dhage
shubham dhage - avatar
Join - Helps to combine two or more tables together. View - Is a combination of two or more tables joined together.
22nd Jun 2016, 5:50 PM
Tijo Joseph
Tijo Joseph - avatar