Hello all,
How do I join the two tables I describe below?
Thank you!
Inserted the following italicized part into an existing query:
dbo_Table_Clients
INNER JOIN
dbo_List_Suffixes
ON
dbo_Table_Clients.Suffix = dbo_List_Suffixes.ID_Suffixes
The tables are on an SQL DB. On the two tables that I am joining I see the following types for the two:
ID_Suffixes : float
Suffix : nvarchar (255)
When I look from access, they appear as number and text.
The "ON" part gave me "Type mismatch" error.
I then wrapped ID_Suffixes in var(). I got "The multi-valued field var(dbo_List_Suffixes.ID_Suffixes is not valid in the specified JOIN clause.
BTW, dbo_List_Suffixes.ID_Suffixes is NOT a multi-valued field.