• Post Reply Bookmark Topic Watch Topic
  • New Topic

Query implementation for sorting  RSS feed

 
lokesh pushpa
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Javalovers,
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!