But if i have data in the both tables it shows me exists, but i don't need this.How to resolve this issue?

Hi all,

Go to xxc_temp and see if you have data with the number

then go to xxc_transaction and see if the data from xxc_temp is already present.

But if i have data in the both tables it shows me exists, but i don't need this.How to resolve this issue?

thanks

If the above is a set of requirement that you have been given (and you have supplied a faithful reproduction of those requirements), then they are malformed. The are grammatically incorrect. They appear to be missing salient information and they contain no contesxt. I would personally push back and tell whoever supplied those 'requirements' to make them much clearer.

I need the know the data moved FROM xxc_temp TO xxc_transactions AND EXISTS IN the xxc_temp table which are today DATE

select temp.<column_list> 
   from xxc_temp temp , xxc_transactions tran
  where temp.<column> = tran.<column>
  and <more joins>
  and temp.<date_column> = sysdate;

AND number = '1234'

mist598 wrote on Thu, 21 August 2014 06:35

AND number = '1234'

The above code is also impossible the way you used it as it is a reserved word.