Re: Inner Joins

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> dsamsom@bristol.ca