Table corrupted

[susu21]

To view my record in application, informations must be in 2 tables A(name,adress,...) and B(job,...)
Here's my problem:
I can see or update my record in application.
But when i do a select in table A (for this record) it returns nothing.
And a select in table B returns me informations linked at this record.

How can i recover data in table A ?
I tryed to unload table A but nothing. It seems like the record doesn't exist in this table (a select count indicates me that it's here.

thanxs

 

[pto]

You state that you tried an unload, does that mean you performed the unload of the table and then loaded the table back in. You have to load the table back inorder to get data.

 

[ManuelPallas]

yes, its possible that a special index is currupted that you are using for the select...try unload and load...if it still don´t work drop the table an re-create it!