Is it possible to perform two inner joins?

pb1uk

Hello all,

I'm new to php and i am cheating a little using Dreamweaver to create a database driven website.

For one of my sql statements i'm trying to perform two inner joins in the same statement but i can't seem to get it to work

Is it possible to do this? Are there any tutorials out there, as i've been unable to find one so far?

Thanks

igorek

select * from
t1 inner join t2 using(col1)
inner join t3 using(col1)
where col1=1;

for inner join the conditional clause always TRUE.

USING is a shortcut if the columns in different tables are foreign keys that you are linking the tables with, basicly the data in both tables in those columns are the same and related.

1andyw

igorek;10942333 wrote:
select * from
t1 inner join t2 using(col1)
inner join t3 using(col1)
where col1=1;

From which table(s) will the data be returned? Will you make a short mock-up to further explain?

Andy

pb1uk

igorek;10942333 wrote:
select * from
t1 inner join t2 using(col1)
inner join t3 using(col1)
where col1=1;

for inner join the conditional clause always TRUE.

USING is a shortcut if the columns in different tables are foreign keys that you are linking the tables with, basicly the data in both tables in those columns are the same and related.

Thanks for your help, gave me a point in the right direction