ms access

dico

Im using PHP with MS access and notice that when joining 2 tables I get an error.

Here is my statement.

SELECT d.name FROM dogs.d,cats.c WHERE d.id=c.id AND d.id=123

I know this works with mysql but I am getting an error with my ODBC MS acess connection. Just basic queries work fine.

Thanks

scambro

Originally posted by dico
Hi

Im using PHP with MS access and notice that when joining 2 tables I get an error.

Here is my statement.

SELECT d.name FROM dogs.d,cats.c WHERE d.id=c.id AND d.id=123

I know this works with mysql but I am getting an error with my ODBC MS acess connection. Just basic queries work fine.

Thanks

dr

I'm pretty sure you want it to look like this:

FROM dogs d

not FROM dogs.d

dico

sorry... I meant to write it without the period.

this still gives me the error.

scambro

Originally posted by dico
sorry... I meant to write it without the period.

this still gives me the error.

dr

I'm confused by your select. Aren't you missing a JOIN expression?

Something like:

SELECT d.name
FROM dogs d, cats c
JOIN cats ON c.id = d.id
WHERE d.id = 123