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
I am writing some PHP code with calls to Mysql. I am trying to do a Inner
join and I am not getting any results back from my query (and no errors).
If I cut the Inner join out of the SQL statement it works.
If I link the MySql tables into Microsoft Access and run the exact SQL
statement it work
