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]

Reply via email to