Additionally, don't just print the data with questions like this...
Take the time to write out:

CREATE TABLE A ...
CREATE TABLE B ...
INSERT INTO TABLE A...
INSERT INTO TABLE A...
INSERT INTO TABLE B...
INSERT INTO TABLE B...

that way we can just copy, pastes, and run your script, and send you a
query that works.