SELECT
a.*, b.pr_name
INTO OUTFILE 'johnoggyresult3.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM
`fileb` AS b
LEFT JOIN
`filea` AS a ON b.pr_hand_size = a.user_hand_size
ORDER BY
a.user_id
SELECT
a.*, b.pr_name
INTO OUTFILE 'johnoggyresult3.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM
`fileb` AS b
LEFT JOIN
`filea` AS a ON b.pr_hand_size = a.user_hand_size
ORDER BY
a.user_id