i have one requirement in sorting. I have a table name as Transaction with 5 columns and i have Transaction_B table having 5 columns both are having one to one mapping. Transaction_B table having a1, a2...etc. columns. When ever user update the a1, a2 columns then transaction will store into Transaction_B table otherwise Transcation wont store in Transaction_B table. I have to sort the Transaction_B table a1, a2 columns but sorting is happening only on updated values in Transaction_B table but i need to get the Transaction table values also. NOTE: In Transaction_B table only updated values only will store from Transaction table. So i will get null values from Transaction Table. Now i need the query for getting Transaction_B table values updating the null values with "NO" message.
Ex: Transasction Table : Columns: aa1, aa2, aa3, aa4, aa5
Transaction_B Table: A1, A2, A3, A4, A5
Modules: Detail Module
Detail Search Module
In Detail module we are updating 3 values as "YES". Here Transaction_B values are updated. I mean A1,A2 columns are updated in Detail module. Now Transaction_B table updated with 3 values as "Yes". I have Detail search Module, here i need to sort on A1, A2 are updated with "Yes". If i done the sorting on A1,A2 columns i m getting only updated values. But i want all the values from Transaction Table with Null values are updated with "No" value.
Please suggest any approach or query to do this requirement.