Unmatched query issue (1 Viewer)

[virencm]

Hello All,

The attached database has 2 tables, Master and MXI.

there are 3974 records in Master and 3950 records in MXi. I need an unmatched query that looks at both these tables and lists the 24 unmatched records .

I need to find the record for field "CONFIG_POS_SDESC" in table Master that doesn't appear in MXi

I sounds really simple and i cant work it out. please help

Viren

 

[JHB]

..
there are 3974 records in Master and 3950 records in MXi. I need an unmatched query that looks at both these tables and lists the 24 unmatched records .

Oh - there are a lot more as 24 unmatched records - you've a lot of records like below, (marked with red), which aren't in MXI.
A sample:

ENGINE ASSY (ENG #1 (506)) ->72-56-00-5610 (D725610(B725002/C725601)-FRAME LPT)

 

[virencm]

Thanks for pointing that out JHB. I didnt realise that. Let me revaluate and see if it works after amending the records.

Thanks again
Viren

 

[virencm]

The query works!!!! Thanks JHB

 

[JHB]

Good you got it.

 

[virencm]

hi JHB,

i am having another issue with the unmatched query and i cannot figure this out.

i have attached a sample database. i am comparing the config with the inventory and this should bring up values that are not in the inventory but it doesnt.

what am i doing wrong?

Can you help please?

 

[JHB]

You need a link between the Config_Master.SERIAL_NO and Inventory.ASSEMBL_SERIAL_NO.

SELECT Config_Master.ASSMBLY_PART_NO, Config_Master.CONFIG_SLOT_CD, Config_Master.CONFIG_POS_SDESC, Config_Master.PART_NO_SDESC, Config_Master.SERIAL_NO
FROM Config_Master LEFT JOIN Inventory ON (Config_Master.SERIAL_NO = Inventory.ASSEMBL_SERIAL_NO) AND (Config_Master.[CONFIG_POS_SDESC] = Inventory.[CONFIG_POS_SDESC])
WHERE (((Inventory.CONFIG_POS_SDESC) Is Null));

 

[virencm]

Awesome!! Thanks JHB

 

[JHB]

You're welcome.
If it helped you, please do not hesitate to click on the "Thumb up"