Ron Piggott wrote:
I am writing a blog application.
Table blog has the blog entries
Table blog_owners is the user profiles
Table blog_responses is responses to the blog entries
I am writing the module where the user approves or deletes user comments
when the blog entry is in 'moderated' mode.
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
riginal Message -
From: Bastien Koert <[EMAIL PROTECTED]>
To: Ron Piggott <[EMAIL PROTECTED]>,PHP DB Posts
Date: Sun, 21 Oct 2007 09:41:21 -0400
Subject: RE: [PHP-DB] inner join
>
> select [table.field]
> from
> table1 t1 inner join table2 on t1.some_field = t2.
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
You need to have "keys" in each table to join them together.
Once you have those "keys" in place, you can match the keys
across the tables and use a WHERE clause to filter the results.
'Luck!
-Mike
- Original Message -
From: "José Moreira" <[EMAIL PROTECTED]>
To: "Php-Db" <[EMAIL PROTEC