This is a simple thing that I've just have a brain freeze on right now... I got two tables (tblMain & tblStation) They are linked by the field Sta_Name... How do I get the Inner Join going on my SQL statement...

I got

SELECT * FROM tblMain INNER JOIN tblStation ON tblMain.Sta_Name = tblStation.Sta_Name ORDER BY... yadda yadda

Could somebody help me out on the syntax...
Thanks