Need help with SQL statement ...

[TheBionicOrange]

OK here goes ....


I need to look in 2 files, say FileA and FileB for an item, say a lump of cheese.

If I "drive" my SQL from FileA and "lump of cheese" does not exist, is there a way of making the SQL look in FileB ?

At the moment if it can't find "lump of cheese" in File A it DOESN'T look in FileB (which as it happens is exactly where "lump of cheese" lives !)

I've tried a left outer join, a right outer join, and nested select statements, but it seems to me that if the item your looking for doesn't exist in the file you are driving your statement from, then it stops right there and WON'T look in any other files regardless.

Is that a correct assumption to make ?

Am I making any sense ?

Cheese haters need not apply !