Unmatched query multiple criteria

[Tlou5831]

I am attempting to compare 2 tables in my DB and find unmatched criteria.

There are 2 different fields in each database that need to be compared.

Tbl_AppUsers

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

Tbl_RoleSettings

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

I would like to perform a query that the fields that basically says If TBL_APPUsers.Role + TBLAPPUsers.Settings <> TBL_RoleSettings.Role + TBL_.Settings show in the results in the query.

I attempted to do this in the unmatched query wizard but you are only able to compare 1 field.

Thanks for the help.

[ck9663]

I am attempting to compare 2 tables in my DB and find unmatched criteria.

There are 2 different fields in each database that need to be compared.

Tbl_AppUsers

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

Tbl_RoleSettings

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

I would like to perform a query that the fields that basically says If TBL_APPUsers.Role + TBLAPPUsers.Settings <> TBL_RoleSettings.Role + TBL_.Settings show in the results in the query.

I attempted to do this in the unmatched query wizard but you are only able to compare 1 field.

Thanks for the help.

Try this:

select * from Tbl_AppUsers where TBL_APPUsers.Role + TBLAPPUsers.Settings  not in (select TBL_RoleSettings.Role + TBL_.Settings from Tbl_RoleSettings)
 

-- CK

[Tlou5831]

Try this:

select * from Tbl_AppUsers where TBL_APPUsers.Role + TBLAPPUsers.Settings  not in (select TBL_RoleSettings.Role + TBL_.Settings from Tbl_RoleSettings)
 

-- CK

I receive the Enter Parameter value for the TBLRoleSettings table