Good man. That' probably what he really wanted to do.
On 10/21/07, Neil Smith [MVP, Digital media] <[EMAIL PROTECTED]>
wrote:
>
> At 19:31 19/10/2007, you wrote:
> >Message-ID: <[EMAIL PROTECTED]>
> >Date: Fri, 19 Oct 2007 09:24:38 -0600
> >Subject: union/select statement & number of columns
> >
At 19:31 19/10/2007, you wrote:
Message-ID: <[EMAIL PROTECTED]>
Date: Fri, 19 Oct 2007 09:24:38 -0600
Subject: union/select statement & number of columns
Hello all, I receive an error of the following: The used SELECT
statements have a different number of columns. Any help, pointers,
tutorials a
Thanks guys. That is really cool ... 3 tables all working together. Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 <[EMAIL PROTECTED]>:
>
> C
Along with the formal inner join syntax Bastien pointed out, isn't doing
"WHERE t1.id = t2.id AND t2.id = t3.id" the same thing?
select [table.field]
from
table1 t1, table2 t2, table3 t3
where t1.some_field = t2.some_field
and t1.some_field = t3.some_field
-TG
- Original Message -
Fr
select [table.field]
from
table1 t1 inner join table2 on t1.some_field = t2.some_field
inner join table3 t3 on t1.some_field = t3.some_field
where [clauses as needed]
bastien
> From: [EMAIL PROTECTED]> To:
php-db@lists.php.net> Date: Sun, 21 Oct 20
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