JOIN questions

[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

 

[kingston via AccessMonster.com]

From the MS website (
http://office.microsoft.com/en-us/assistance/HA010345551033.aspx):
"Note You cannot define a full outer join in an Access database"

You might have better luck with a subquery and a NOT IN criteria if you want
data that doesn't exist within a defined set.

 

[ksun via AccessMonster.com]

OK, thank you. Still, I'm confused why the FULL OUTER JOIN failed.

From the MS website (
http://office.microsoft.com/en-us/assistance/HA010345551033.aspx):
"Note You cannot define a full outer join in an Access database"

You might have better luck with a subquery and a NOT IN criteria if you want
data that doesn't exist within a defined set.

Hi,

[quoted text clipped - 12 lines]

Thank you!
Kathy

 

[John Vinson]

OK, thank you. Still, I'm confused why the FULL OUTER JOIN failed.

Because the Microsoft developers of Microsoft Access 1.0 (and all
versions since) chose not to implement that portion of the SQL
standard.

John W. Vinson[MVP]