I do not have a copy of Access 2007 right now...
Did they add Full Outer Join support to it?
I am wondering because it would simplify things a lot if it did.
If not, any rumors of it being added?
I know there are workarounds... Jet you can do a union query and there is the SQL version that runs locally (Desktop/Personal/Express) but neither is too appealing.
I'm looking at having to write a tool to build a full outer join query within Access for repeated use against various tables and I'd rather stick to simple SQL statments if possible.
Did they add Full Outer Join support to it?
I am wondering because it would simplify things a lot if it did.
If not, any rumors of it being added?
I know there are workarounds... Jet you can do a union query and there is the SQL version that runs locally (Desktop/Personal/Express) but neither is too appealing.
I'm looking at having to write a tool to build a full outer join query within Access for repeated use against various tables and I'd rather stick to simple SQL statments if possible.