Inner Join

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

:cool:

What you've got is right!

Code:

---

SELECT tblMain.* FROM tblMain INNER JOIN tblStation ON tblMain.sta_name = tblStation.sta_name ORDER BY tblMain.sta_name;

---

Can't believe I missed that...

Thanks... it's been a long day.