Don't let MySQL hesitate.

1 DROP TABLE IF EXISTS' W1 ';2 CREATE TABLE' W1 ' (3' Waid 'int( One) not NULLAuto_increment,4' WA1 'varchar(255) COLLATE Utf8mb4_binDEFAULT NULL,5' Wa2 'varchar(255) COLLATE Utf8mb4_binDEFAULT NULL,6   PRIMARY KEY(' Waid ')7) ENGINE=MyISAM auto_increment=3 DEFAULTCHARSET=UTF8MB4 COLLATE=Utf8mb4_bin;8 9 -- ----------------------------Ten --Records of W1 One -- ---------------------------- A INSERT  into' W1 'VALUES('1','w1-1','1'); - INSERT  into' W1 'VALUES('2','W1-2','2');

1 DROP TABLE IF EXISTS' W2 ';2 CREATE TABLE' W2 ' (3' Wbid 'int( One) not NULLAuto_increment,4' Wb1 'varchar(255) COLLATE Utf8mb4_binDEFAULT NULL,5' Wb2 'varchar(255) COLLATE Utf8mb4_binDEFAULT NULL,6   PRIMARY KEY(' wbid ')7) ENGINE=MyISAM auto_increment=3 DEFAULTCHARSET=UTF8MB4 COLLATE=Utf8mb4_bin;8 9 -- ----------------------------Ten --Records of W2 One -- ---------------------------- A INSERT  into' W2 'VALUES('1','w2-1','2'); - INSERT  into' W2 'VALUES('2','w2-2','2');

1 SELECT *  fromW1 Left JOINW2 onW1.wa2=w2.wb22 SELECT *  fromW1 Left JOINW2 onW2.wb2=W1.WA23 4 SELECT *  fromW2 Right JOINW1 onW1.wa2=w2.wb25 SELECT *  fromW2 Right JOINW1 onW2.wb2=W1.WA26 7 8 SELECT *  fromW2 Left JOINW1 onW1.wa2=w2.wb29 SELECT *  fromW2 Left JOINW1 onW2.wb2=W1.WA2Ten  One SELECT *  fromW1 Right JOINW2 onW1.wa2=w2.wb2 A SELECT *  fromW1 Right JOINW2 onW2.wb2=W1.WA2 -  -  the SELECT *  fromW1INNER JOINW2 onW1.wa2=w2.wb2 - SELECT *  fromW1INNER JOINW2 onW2.wb2=W1.WA2 - SELECT *  fromW1 Cross JOINW2 onW1.wa2=w2.wb2 - SELECT *  fromW1 Cross JOINW2 onW2.wb2=W1.WA2 +  - SELECT *  fromW2INNER JOINW1 onW1.wa2=w2.wb2 + SELECT *  fromW2INNER JOINW1 onW2.wb2=W1.WA2 A SELECT *  fromW2 Cross JOINW1 onW1.wa2=w2.wb2 at SELECT *  fromW2 Cross JOINW1 onW2.wb2=W1.wa2

Don't let MySQL hesitate.