Recent content by GraphicsFactory

OK, thanks for the tips. It solved some of my problems. :)

Yes, I am trying to use both tables as a single table. Cool, I will try that. So does this look correct? SELECT * FROM table1 Union All SELECT * FROM table2 WHERE table1.ID = table2.LinkID OR table1.ID = '$ID' ORDER BY table2.dotTimestmp,table1.Timestmp DESC

Thanks, let me try to explain... table1 has a column name of ID along with Title, Descriptions etc... to go along with it. table2 has a column name of LinkID with dotTitle, dotDecription, etc.. to go along with it. I am trying to get the results from both tables and sort them based on their...

I am trying to return the results of two tables with one query. The problem is results from only one table are getting returned. Here is my query... SELECT * FROM table1,table2 WHERE table1.ID = table2.LinkID OR table1.ID = '$ID' ORDER BY table2.dotTimestmp,table1.Timestmp DESC What mistake...