PHP DB - Re: [PHP-DB] inner join

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [PHP-DB] inner join

Rafael Costa Pimenta

2007-10-21, 7:02 pm

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@actsministries.org>:
>
> 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

Sponsored Links