K
ksun via AccessMonster.com
Hi,
I have two questions:
1. I'm trying to do a FULL OUTER JOIN in Access, but it deeps on saying
"Syntax error in FROM clause". Here's my code:
SELECT Query2.*, Query4.*
FROM Query2 FULL OUTER JOIN Query4
ON (Query2.VM_VMONTH = Query4.VM_VMONTH)
AND (Query2.GAMMA_QUANT = Query4.Gam_Quant);
2. Is there a way to select out records that do NOT match via INNER JOIN?
Thank you!
Kathy
I have two questions:
1. I'm trying to do a FULL OUTER JOIN in Access, but it deeps on saying
"Syntax error in FROM clause". Here's my code:
SELECT Query2.*, Query4.*
FROM Query2 FULL OUTER JOIN Query4
ON (Query2.VM_VMONTH = Query4.VM_VMONTH)
AND (Query2.GAMMA_QUANT = Query4.Gam_Quant);
2. Is there a way to select out records that do NOT match via INNER JOIN?
Thank you!
Kathy