Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    the Netherlands

    Unhappy Unanswered: 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

    But now take look at this particular situation:

    CREATE TABLE `table1` (
    `id` int(11) NOT NULL auto_increment,
    `data` varchar(255) NOT NULL default '',
    `created` timestamp(14),
    PRIMARY KEY (`id`)

    Same goes for table 2.
    Now this is my problem: how can i select rows from table 1 with a timestamp `created` that doesn't exist in table 2? the IS NULL trick doesn't seem to work. I guess that is because a timestamp can never be null.

    Thanx in advance!

  2. #2
    Join Date
    Sep 2003
    Outter join

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts