SELECT ProductName.SPID, Price.SSID, ProductName.SCID, ProductName.ProductName, Price.Price INTO OUTFILE '/home/smokeys/public_html/css/output.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM Price INNER JOIN ProductName ON Price.SPID = ProductName.SPID