MySQL AND
Syntax :
WHERE condition1 AND condition2 AND condition3 ...condition n
The MySQL AND Condition is used to test two or more conditions in a SELECT, INSERT, UPDATE, or DELETE statement.
LEFT JOIN keyword returns all records from the left table (table1) and the matching records from the right table (table2). If the records did not match from the right side, then NULL is returned as value for those records. Insert data into certain columns you will need to specify only these columns as part of the statement.
Below example is to understand the BETWEEN Condition.
Table : employee
Table 2 : orders