How Do I Define Alias in MS ACCESS?

[gys67]

Hi I am trying to convert a pl/sql query in MS ACCESS query.
SELECT student_name FROm student s WHERE EXISTS (SELECT * FROM math_club m
WHERE m.student_id = s.student_id)


NOw How do I write this in MS Access?

Please Help
Thanks

 

[SteveR77]

The AS statement is your option to do an alias some SQL languages allow you to leave it out but it is part of the all the standard SQL that exist.


SELECT student_name FROm student s WHERE EXISTS (SELECT * FROM math_club AS m
WHERE m.student_id = s.student_id)



Steve

 

[gys67]

Thanks SteveR77

It works !!!

Thanks a lot again