Translating Access SQL queries into MySQL subqueries.

[timn]

Translating Access SQL queries into SQL subqueries.
--------------------------------------------------------------------------------


I have a query in Access that uses a subquery, I would like some help on translating it into SQL as a subquery so I can use it in an application.

the queries in Access are
the subquery... (query4)

SELECT Movement.DateTime, Movement.StudentID, Movement.Subject, Movement.Teacher, Movement.Destination, Movement.Lesson
FROM Movement
WHERE (((Movement.DateTime) Between #6/15/2007 7:0:0# And #6/15/2007 19:0:0#) AND ((Movement.Destination)="Away" Or (Movement.Destination)="sign out" Or (Movement.Destination)="sign in") AND ((Movement.Lesson)=3)) OR (((Movement.DateTime) Between #6/15/2007 7:0:0# And #6/15/2007 19:0:0#) AND ((Movement.Destination)="sign in"));

the main query...

SELECT NStudTT.Student, NStudTT.Day, NStudTT.Lesson, NStudTT.Subject, Query4.DateTime, Query4.Subject, Query4.Teacher, Query4.Destination, Query4.Lesson, NStudTT.StudentID
FROM Query4 RIGHT JOIN NStudTT ON Query4.StudentID=NStudTT.StudentID
WHERE (((NStudTT.Day)=5) AND ((NStudTT.Lesson)=3) AND ((NStudTT.Subject) Like "stu*"));

thank you

[Rabbit]

Perhaps this is a question better suited for the MySQL forum? I don't know the syntax differences between Access and MySQL so I can't translate but the MySQL experts should be able to convert the syntax for you without having to know the exact syntax for Access.

Let me know if you want to move it.

Edit: I see you've already posted in the MySQL forum, disregard this post.