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