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 Access syntax. From PHP, they follow MySQL syntax.
Saludos,
Pablo Vera
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Thursday, January 11, 2001, 3:08:52 PM, debra wrote:
sd> I am writing some PHP code with calls to Mysql. I am trying to do a Inner
sd> join and I am not getting any results back from my query (and no errors).
sd> If I cut the Inner join out of the SQL statement it works.
sd> If I link the MySql tables into Microsoft Access and run the exact SQL
sd> statement it works with the correct results.
sd> Is there any special syntax that PHP requires for inner joins? I'm running
sd> PHP 3.0.11 and Mysql 3.22.34 on NT 4.0 with Apache (of course).
sd> 'SELECT tbl_cip.CIP, tbl_cip.Originator, tbl_cip.Coordinator,
sd> tbl_cip.AproveCancel,
sd> tbl_cip.Actionees, tbl_cip.Director, tbl_cip.Repeat,
sd> tbl_cip.HoldPending,
sd> tbl_cip.Auditor, tbl_cip.Verifier, tbl_cip.Date
sd> FROM tbl_cip
sd> INNER JOIN tbl_formid ON tbl_cip.FormID =
sd> tbl_formid.FormID';
sd> Debra Samsom
sd> Bristol Aerospace Ltd.
sd> (204) 775-8331 3402
sd> [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]