Problem with a query from multiple tables

[Miha A]

Hello!

I have DB called "DB_1_2011". I would like to create a view, but I first want to see/check the result (retreived data) in the Query Browser. I'm having problems with the syntax, because I pull data from more then one table:

so, this query returns no data (but I'm sure it should, because I checked it in MS Access via linked tables to MySql server):

SELECT tbl1.StrankaID As a, tbl1.strSkrajsanNaziv As b, tbl2.strSkupina As c FROM DB_1_2011.tblStranka tbl1 JOIN DB_1_2011.tblSkupina tbl2
ON tbl1.StrankaID = tbl2.StrankaID;

if I try something more simple it works (e.g.):
SELECT tbl1.StrankaID As a, tbl1.strSkrajsanNaziv As b FROM DB_1_2011.tblStranka tbl1;

Could someone pliz tell me where there's an error in my "first" select statement??

Thx in advance!
M