I took all my junk and ran it again. I thought and the book says that a FULL OUTER JOIN will give you the stuff in the left table and the stuff in the right table like the old simulated outer join using UNION.

It seems that I get everything except what is missing in the left table and present in the right table.

THis has had me perplexed for quite some time. I tried the old fashion UNION out join and got the same thing. I figured the data was bad for that day so I ran another day with everything in both tables. It ran fine. As soon as ai took an item out of the left table the same result happended.

I always seem to get wierd results. I have bmp that are missing from the VFP directory. When I use the exsiting stuff in the gallery, it tells me that it's looking for the files but does not find them. I have uninstalled and reinstalled the program until I am blue in the face. I have even loaded the updates to service pack four and still get no results.

Man I'm frustrated.