Re: inner join
| From: | Rafael Costa Pimenta | Date: | Sun, 21 Oct 2007 16:11:32 +0000 |
| Subject: | Re: inner join | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44246@lists.php.net to get a copy of this message | ||
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