Four scenarios for MySQL queries

1 Common Connection Query

Select table 1 field 1, Table 2 field 2,from table 1, table 2,where table 1. field 1== table 2. Field 2

2 INNER JOIN query

Select table 1 field 1, Table 2 field 2,from table 1 INNER JOIN table 2 on table 1. field 1== table 2. Field 2

Similar to normal queries

3 left JOIN query, leftist query

Select table 1 field 1, Table 2 field 2,from table 1 left JOIN table 2 on table 1. field 1== table 2. Field 2

Gets data from the left table for the selected field, even if the right table is empty

4 Right Join query

Select table 1 field 1, Table 2 field 2,from table 1 right JOIN table 2 on table 1. field 1== table 2. Field 2

Gets data from the right table for the selected field, even if the left table is empty

5 full join query, fully linked query

Select table 1 field 1, Table 2 field 2,from table 1 full JOIN table 2 on table 1. field 1== table 2. Field 2

Returns the data for a table as long as the field is not empty

Four scenarios for MySQL queries