I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not seem to be matched properly when I run the query table tool. I've tried using the following expression in the query table expression field to indicate that these are the fields to be joined:
'FishingAreaGroundFishNafoUnit.Code' = 'FishArea_Code_homeports_TotalValue.Code'
However instead of returning a table with just a few hundred records, I get one with 42,000 records which makes no sense at all.
I think I may be doing something wrong (perhaps the problem is with my query), but I'm not sure what. When I verify my query in the query builder window, I keep getting a message saying
The expression was verified successfully but no records were returned
which does not make any sense as there should definitely be some matches.
I've also been using his thread (bottom post) to guide myself in creating the query table http://forums.esri.com/Thread.asp?c=93&f=1728&t=172344in