Hi there Gurus,
Sorry to be a pain! I've been asked to optimise an existing application that queries 3 or four tables, and now I'm adding another table.
Ideally if data on one inner join returns null, I want to try another table, but I can't do two queries because of the way this whole thing works.
My question is:-
How can I stop the WHOLE query from running/returning no records if one of the inner joins returns nothing?
I've been puzzling over this for a few days now, and I'm sure as it's achievable, just need a pointer as to how to put an if else type thing in there!
Thanks for reading,