Saturday 15 September 2012

mysql - SELECT INTO OUTFILE two tables with condition error -


I am trying to export the results of my query in the file as a report. I'm using two tables.

SELECT 'Test1', 'Test2', 'Test3', 'First Name', 'Last Name',

/ P>

unions all

SELECT TESTS.TEST1, TESTS.TEST2, TESTS.TEST3, STUDENT.FNAME, STUDENT.LNAME < / P>

Where Test. STUNT_SI_ID = STUDENT.S_ID

Outreachable / path / 'in records'

By trial, student;

I am getting a syntax error for the WHERE section

Your queries are messing up The syntax is:

  select ... from ... ou ... outreach ... ...   

your FROM

No comments:

Post a Comment