SQL table join

Select * From xxaa A, xxbb B where a. ID (+) = B. IDD; -- right join, based on table B, matching all outputs in Table B
Select * From xxaa A, xxbb B where. id = B. <Div (+); -- left join. Table A is used as the base table. All outputs matching table A are equivalent to left join and left Outer Join.
Select * From xxaa A, xxbb B where a. ID = B. IDD; -- = join a, B tables are matched before output
Select * From xxaa a left join xxbb B on (A. ID = B. IDD); -- left inner join
Select * From xxaa a right join xxbb B on (A. ID = B. IDD); -- right inner join
Select * From xxaa a full join xxbb B on (A. ID = B. IDD); -- completely join -- the Union of table A and Table B
Select * From xxaa a inner join xxbb B on (A. ID = B. IDD); -- Inner join -- intersection of table A and Table B
Select * From xxaa a left Outer Join xxbb B on (A. ID = B. IDD); -- left Outer Join
Select * From xxaa a right Outer Join xxbb B on (A. ID = B. IDD); -- right Outer Join
Select * From xxaa a full outer join xxbb B on (A. ID = B. IDD); -- completely outer
Select * From xxaa a join xxbb B on (A. ID = B. IDD); -- equivalent to = join