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.
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.