Hi there, I have a problem that I cannot seem to solve. I'm using MySql and query it using PHP. I have create table ABC with field called "number" containing (1,4,6,10) How is to select all number form 1 to 10 which are not in that field so the output somehow like this : +--------+ | Number | +--------+ | 2 | | 3 | | 5 | | 7 | | 8 | | 9 | +--------+ Thanks, Hansen
