MySQL problem.

Use MySQL for INNER JOIN, LEFT JOIN (A, B), RIGHT JOIN (A, B) WITHOUT using JOIN

Data:

DO NOT USE JOIN keyword to get these results:

Table - A Table B b In age 10 5 LN-534 20 LN-20 23 11 LN-11 10 31 LN-31 21 19 LN-19 45 18 LN-18 44 78 87 99 LN-99|9 a id a fn b id 1 RC-1 5RC-5 10 RC-10 15RC-15 3 RC-3 19 RC-19 7 RC-7 1 LN-1 4 5 6 2 LN-2 4 LN-4 10