special join query

[Guest]

i have two tables([LIVE], [TEST]) each table contains two fields (mnemonic,
barcodes)

the mnemonics in each table match, but the LIVE table may have more barcodes
than in TEST.

the joined field would be mnemonics
how do i query the results that display the barcodes that are in LIVE but
not TEST ?

 

[Marshall Barton]

i have two tables([LIVE], [TEST]) each table contains two fields (mnemonic,
barcodes)

the mnemonics in each table match, but the LIVE table may have more barcodes
than in TEST.

the joined field would be mnemonics
how do i query the results that display the barcodes that are in LIVE but
not TEST ?

SELECT Live.*
FROM Live LEFT JOIN Test
ON Live.barcodes = Test.barcodes
WHERE Test.barcodes Is Null

 

[Guest]

what if both tables contain barcodes, but the barcodes are different for the
same mnemonic ?

i have two tables([LIVE], [TEST]) each table contains two fields (mnemonic,
barcodes)

the mnemonics in each table match, but the LIVE table may have more barcodes
than in TEST.

the joined field would be mnemonics
how do i query the results that display the barcodes that are in LIVE but
not TEST ?

SELECT Live.*
FROM Live LEFT JOIN Test
ON Live.barcodes = Test.barcodes
WHERE Test.barcodes Is Null

 

[Marshall Barton]

I guess I'm not sure what you want. Maybe this is it?

SELECT Live.*
FROM Live LEFT JOIN Test
ON Live.barcodes = Test.barcodes
AND Live.mnemonic = Test.mnemonic
WHERE Test.barcodes Is Null
--
Marsh
MVP [MS Access]

what if both tables contain barcodes, but the barcodes are different for the
same mnemonic ?

i have two tables([LIVE], [TEST]) each table contains two fields (mnemonic,
barcodes)

the mnemonics in each table match, but the LIVE table may have more barcodes
than in TEST.

the joined field would be mnemonics
how do i query the results that display the barcodes that are in LIVE but
not TEST ?

SELECT Live.*
FROM Live LEFT JOIN Test
ON Live.barcodes = Test.barcodes
WHERE Test.barcodes Is Null