Query Error

2001-10-22 Thread Bruno Faé
Hi ! I´m trying to query some news with multiple rows in my database. I´m receiving an error when i use: SELECT table1.*, table2.table2_row FROM table1,table2 ORDER BY table1_row but, if I try: SELECT table1.table1_row, table2.table2_row FROM table1,table2 ORDER BY table1_row or SELECT

What can I do ?

2001-05-25 Thread Bruno Faé
Hello, I´m Brazilian and a new subscriber of this list. (sorry my english) I´m working with MySql and with a 100.000 rows table, this table is growing 300 rows in each day. How can I arrange this information to get a good performance of my queries (my SELECT´s) ? We intend to do this: Work with