I am using PHP 4.1 with the ODBC driver on MS Windows 2000, running IIS. I
am trying to submit a SQL statement with multiple outer joins to a MS Access
database. Does anyone know the syntax for creating such MULTIPLE outer
joins? As it is, my current SQL statement drops rows for which certain
columns have NULL values. Thanks, Bill.
My current, inner join syntax is:

$class_query = "SELECT sample.Sample, type.type_name, chon_class.class_name,
chon_group.groupname, brecciation.brec_type
FROM sample,type,chon_class,chon_group,brecciation

WHERE sample.type = type.type
AND sample.chon_class = chon_class.chon_class
AND sample.chon_group = chon_group.chon_group
AND sample.brecciation = brecciation.brecciation

AND sample.type=$met_type
AND chon_class.class_name LIKE '%$chondritic_class%'

ORDER BY chon_group.groupname,brecciation.brec_type";




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to