SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE A ([AID] int, [name] varchar(1)) ; INSERT INTO A ([AID], [name] ) VALUES (1, 'a'), (3, 'b'), (5, 'c'), (7, 'd'), (9, 'e') ; CREATE TABLE B ([BID] int, [attr] varchar(1)) ; INSERT INTO B ([BID], [attr] ) VALUES (1, 'v'), (2, 'w'), (3, 'x'), (4, 'y'), (5, 'z') ; SELECT * FROM A INNER JOIN B ON A.AID = B.BID; SELECT * FROM A LEFT JOIN B ON A.AID = B.BID; SELECT * FROM A RIGHT JOIN B ON A.AID = B.BID; SELECT * FROM A LEFT JOIN B ON A.AID = B.BID WHERE B.BID IS NULL;