selecting from 3 tables

vocoder

I use the following select statement to select everything out of 3 tables....yet mysql gives me an error...am i doing something wrong?

SELECT t1., t2., t3.* FROM t1, t2, t3 ORDER BY t1.year AND t1.seq DESC

if i run this through phpmyadmin it says "Got error 28 from table handler"

YappyDog

Is there any relationship between the three tables?

What are the columns in each table?

vocoder

each table has a year and seq which are related

2002, 102
2002 , 103
2001, 001
2001,002

for example.

I've tried select * from t1, t2, t3 where t1.year = t2.year
and t1.seq = t2.seq
and t2.year = t3.year
and t2.seq = t3.seq"

but that doesn't work....well it doesn't give an error, but it times out. and if add the ORDER BY statement at the end, then it gives me the Error 28 (ran out of space or something like that?)

YappyDog

Instead of using the wildcard, I would try naming each column you want to select. Since they are in each table, you'll then need to use an alias for each one. Try:

select t1.year as t1year, t2.year as t2year, t3.year as t3year, t1.seq as t1seq, t2.seq as t2seq, t3.seq as t3seq
from t1, t2, t3 where t1.year = t2.year
and t1.seq = t2.seq
and t2.year = t3.year
and t2.seq = t3.seq