I have a table called custrate using the following design and records.
Essentially custrate records should come in pairs, but the database I'm working on is messed up ([rateid 120-129 goes with rateid 200] AND [130-139 goes with 300]). What sql statement can I run inorder to select the custid of the records that are missing there corresponding X00 rate? I hope this is clear.

The custid's that should be returned are 7,8,9, and 10.

Thanks in Advance

okay, look, here's the deal

you've asked two other very similar questions in the SQL Server forum

Complex Join, I think.
Probably an easy JOIN. I but I don't know

both of which i answered, but got no acknowledgement from you

now this thread, in the mysql forum -- WTF?

i don't really want to keep helping you if your problem keeps sliding around like this

you should've asked the real question, in the appropriate forum, in the first place

I don't mean for it to appear like I'm trying to get the answer from some one else. The post in the MSSQL forum was for a MSSQL database which I use for work. I'm not at work now and I only has access to mySql database. So I created a database similar to the database from work to see if I could find the result I'm looking for here at home. I don't know wether the other statement will work or not cause I haven't run it on a MSSQL database. However it definitely did not work with my MySql server. I do appreciate you response and when I get a change to see if it work I'll provide feed back to it. Thanks.