This is something our organization needs to develop a strategy around, and I'm a bit confused. Most of our front end apps are web based, and pass parameters to...

Unless I'm missing something, you could make your life easier by treating this as two separate queries and joining the results with UNION. This is exactly the type of...

Is there a way to do an inner join on 2 tables where table a has data but table 2 does not.

Matt,

What is the outcome you are trying to...