Hi,
I'm back again with another question!!
I'm trying to do an outer join in PSQuery and retrieve information from the job table. As the job table has an effdt Max Subquery in it I'm using the trick of placing OR A.EFFDT is NULL so that the outer join works.
This is working for nearly everybody in my result set except where they have a future dated row in the job table. If they do the outer join doesn't work and they drop from the results completely.
Do you have any tricks or solutions which can solve this? It's a massive query already and I'd like to avoid doing a union if possible. The client only wants an additional field and this is causing me a headache!
Thanks in advance.