Validating data [message #357660] |
Thu, 06 November 2008 03:16  |
sheetalda
Messages: 2 Registered: November 2008
|
Junior Member |
|
|
Hi
Welcome to Orafaq. You must try to follow the posting guidelines, particularly when it comes to formatting your posts the guidelines it makes it more possible for people to properly understand your requirements.
[Edit pablolee: I mucked this up and accidentally edited this msg instead of replying. Will try to get the OP to repost his question]
[Updated on: Thu, 06 November 2008 08:27] by Moderator Report message to a moderator
|
|
|
Re: Validating data [message #357878 is a reply to message #357660] |
Fri, 07 November 2008 00:31   |
sheetalda
Messages: 2 Registered: November 2008
|
Junior Member |
|
|
Hi all
I have to validate the following data in a single query.Please help
SELECT * FROM conv_ch_chqbk_issue_brains
This table contains chq issued
REF_CHQ_START_NO REF_CHQ_END_NO
00000000200 00000000250
00000000260 00000000280
SELECT * FROM conv_ch_stop_chq_brains
This table contains Stooped cheques.
validate all the cheques in this tables must be present in the range in conv_ch_chqbk_issue_brains for that account.
REF_STP_CHQ_ST_NO REF_STP_CHQ_END_NO
00000000201 00000000210
00000000248 00000000249
00000000200 00000000252
00000000252 00000000255
00000000245 00000000265
Rows in red color are invalid rows need to report same.
|
|
|
Re: Validating data [message #357880 is a reply to message #357878] |
Fri, 07 November 2008 00:37  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
You had a chance to repost correctly reading pablolee reamrk and guidelines, why didn't you do it?
Regards
Michel
|
|
|