Hi, you could use: select * from pacients p inner join clinics c on (c.idclinics = p.idclinics) inner join state s on (p.iodstate = s.idstate) and so on... you can use inner join or left join this way with many tables, view, procedures e etc.. 2007/10/21, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx>: > > Can you inner join 3 tables together? Do you know what the syntax would > be? > Ron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Atenciosamente, Rafael C. Pimenta Programador - CTT Integration Group
