Ok I think I've found the problem. I need to go back through all my code it looks like some of the AssetID's are getting written as a number and some are writing then as text. I put together two test tables with only text and was able to query across those with no issues just as I should. Thanks everybody for the help this is going to make things alot easier once I fix these few issues.