Join trouble

I'm a little rusty with using JOINs in SQL. I'm trying to use a query that will take the Grade from Grade_View and show the Grade from TechGroup only if they match up. Here's what I have so far, but it doesn't work:



"select TechGroup.Grade FROM TechGroup INNER JOIN grade_View ON TechGroup.Grade = Grade_view.Grade"



Anyone have any ideas?



Thanks

Outside of not including the ";", which may or may not be needed, I can't see anything wrong with it. What error messages are you getting, which type of DB are you running this against.



Is the Field "Grade" the same type and size in both tables?



In Your current data, is there any that match?



S-