SELECT [Cno.] [Csubno.] Type Rid rdate status FROM {Your_Table_Name} WHERE [Cno.] = [Cno.] AND [Csubno.] = [Csubno.] AND status <> status
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)