Hello, I have a question about selecting multiple tables. I have five tables that I'm querying.
Basically, this would allow the user to view only his/her postings from all five tables. These tables
are catagories. The tables are queried by that users' ID.
i.e Select imagefile,message from table1,table2,table3,table4,table5 where table1.userID=table2.userID etc.)
O.K., what has happened is that the query takes a very long time. Is there another way this can be done so that the query runs faster?
This is done in PHP.
Thanks
KJ
Basically, this would allow the user to view only his/her postings from all five tables. These tables
are catagories. The tables are queried by that users' ID.
i.e Select imagefile,message from table1,table2,table3,table4,table5 where table1.userID=table2.userID etc.)
O.K., what has happened is that the query takes a very long time. Is there another way this can be done so that the query runs faster?
This is done in PHP.
Thanks
KJ