what is joining in views sql code example

Example 1: joins and views sql

SELECT *
FROM   driver
;

Example 2: joins and views sql

SELECT *
FROM   car
;

Example 3: joins and views sql

//traditional JOIN 

SELECT *
FROM   car,driver
WHERE  owner = name
;