1. inline ainnerjoinbona. idb. id to query the id records of both tables. 2. Left outer aleftjoinbona. idb. id as long as Table a has a, and table B does not have a corresponding
1. inline a inner join B on a. id = B. id to query the id records of both tables. 2. left outer a left join B on a. id = B. id as long as Table a has a, B can have no corresponding
1. inline
A inner join B on a. id = B. id
Query the id records of both tables.
2. Left outer
A left join B on a. id = B. id
As long as Table a has a, but table B does not have a corresponding record. All fields in Table B are replaced by null.
3. Right outer
A right join B on a. id = B. id
In contrast to left Outer Join, Table a does not have a corresponding record as long as table B has one.
4. Full outreach
A full join B on a. id = B. id
Both Table a and table B can exist.
,