their website sucks and also an old version of the software that is no longer supported but SQL is still SQL, just the syntax is different between different vendors.

any how...

hi Nigel

thats the bitch... stochist has about 15,000 records and stoctran has about 400

but all that is being returned is 35 records and cannot understand why.

tables are not corrupted.

The database...

Both tables have exactly the same fields but different record data and tried this!!

select * from stoctran

union all

select * from stochist

but does not give me all the data from both...

Thanks guys but did not work.

The package I am using (accounting system) uses DBISAM from elevate software and as a newbie discovering the difference in SQL syntax between different versions....

thanks I will try it and report back.