sql - join 78 specific codes from created table to linked table. Can't use IN() function (character limit), Can't do RI -


i have db (access 2010) pulling data from, trying make easier pull specific cases instead of mucking in excel.

we have 78 product type codes classify account type. unfortunately can't use in() function because there many characters (there 1024 char limit). looked online , suggested make table inner join on product codes want.

i created table codes want pull, joined on productcodetype in linked database table. unfortunately when run sql nothing shows up, blank. tried different join combinations no avail, read further , found can't enforce referential integrity on linked db tables non-linked db tables.

i think problem i'm not sure, , don't know if i'm using right language, can't find similar issue mine i'm hoping it's easy fix , i'm not thinking right way.

is there way select cases (78 product type codes) large database using in() or reference table when can't create new table in linked db?

thank you, k

you must use 2 tables , build query join them. if join don't return result, sure joined fields of same data type , realy share same values.

if data source excel, sure there isn't trailing blanks or other 'invisible' character.


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -