view with join in sql code example

Example 1: joins and views sql

//traditional JOIN 

SELECT *
FROM   car,driver
WHERE  owner = name
;

Example 2: joins and views sql

SELECT *
FROM   car
;