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!

Register Log in
  • Congratulations gkittelson 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: *

  • Users: J0VE
  • Order by date
  1. J0VE

    complicated groupwise max / join query

    I'm having this very complicated problem getting the right results out of my tables. These are the tables: CREATE TABLE `Answers` ( `id` int(10) unsigned NOT NULL auto_increment, `question_id` int(10) unsigned NOT NULL default '0', `session_id` varchar(255) NOT NULL default ''...
    • J0VE
    • Thread
    • Replies: 0
    • Forum: MySQL
  2. J0VE

    select timestamp that doesn't exist in other table

    darn... i'm going to try and find why my resultset contains all records from table1....
  3. J0VE

    select timestamp that doesn't exist in other table

    Some of you probably know this trick to select rows from one table with an ID value that doesn't exist in another table: mysql> SELECT table1.* FROM table1 -> LEFT JOIN table2 ON table1.id=table2.id -> WHERE table2.id IS NULL; But now take look at this particular situation: CREATE TABLE...
    • J0VE
    • Thread
    • Replies: 5
    • Forum: MySQL

Part and Inventory Search

Back
Top