Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GraphicsFactory

    join returning results from two tables...

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

    join returning results from two tables...

    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
  3. GraphicsFactory

    join returning results from two tables...

    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...
  4. GraphicsFactory

    join returning results from two tables...

    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...

Part and Inventory Search

Back
Top