I am trying to export the results of a querie
SELECT * FROM table a, table b WHERE a.column = b.column;
and when I use
load data outfile 'C:/Users/Name/Documents/file.txt'
I recieve an error that says my MySQL syntax is wrong.
"You have an error in your SQL syntax...for the right syntax to use near 'outfile 'C:/Use..."
I don't know what I'm doing wrong but it should be a simple export command.