Debra:
I encountered something similar a while ago when I was using
version 3.22, and I seem to recall from the MySQL manual that
INNER JOINS are performed like this:
SELECT t1.a, t1.b, t2.c FROM t1, t2 WHERE t1.a = t2.a
When youn link tables to Access, the SQL statements used should
follow A
Your question is already answered, but for future ref, I debug all my SQL by
running it at the command prompt to ensure that the version of MySQL that I'm
using actually recognises the commands (alternatively trawl through the command
list in the MySQL manual to see what the developers have to say
The INNER JOIN condition is not allowed in mySQL prior to version 3.23.16.
Just put the test "tbl_cip.FormID = tbl_formid.FormID" in the WHERE clause.
~~LF
"samsom, debra" wrote:
> I am writing some PHP code with calls to Mysql. I am trying to do a
> Inner
> join and I am not getting any resul
