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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.