Re: Select question..... is there a way to do this?

[Rodrigo De León <rdeleonp@xxxxxxxxx>]

On Aug 3, 11:17 pm, k...@xxxxxxxxxxxxx (Karl Denninger) wrote:
> Ideas?

SELECT item.user, item.subject, item.number
  FROM item, seen
 WHERE item.user = seen.user
   AND item.number = seen.number
   AND item.changed > seen.lastviewed
UNION
SELECT item.user, item.subject, item.number
  FROM item, seen
 WHERE item.user = seen.user
   AND seen.number IS NULL
   AND item.changed > seen.lastviewed;


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings