Query wizard

[croy]

I have a query that i want to turn into an Inner\outer join, instaed of Ansi.

can Access do that for me ?

(the query):

SELECT ES2.Subject_desc AS 2nd_subject, employee_education.*, diplomas.*,edu_subjects.*
FROM employee_education, diplomas, edu_subjects, edu_subjects AS ES2
WHERE (((employee_education.Diploma_Subject1)=[edu_subjects].[subject_id]) AND ((employee_education.Diploma_Subject2)=[ES2].[subject_id]) AND ((employee_education.diploma)=[diplomas].[deg_id]));

 

[tlbroadbent]

No. Access will not convert the code from the OLD style JOIN to the ANSI standard INNER/OUTER JOIN syntax. You will need to convert it yourself. It should be rather easily done in the query designer grid. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.