0

Fields that can participate in a join condition

Recently, I have noticed that not all fields from a table are listed in the drop-down for the join condition. What determines if a field shows up?

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • In  my opinion, only the fields of similar data types will show up and not everything.

    Reply Like
    • Kiran Chowdary Komati, yes, that is true, but in this case, the table in question is being joined to itself. I expected all of the fields to be available.

      Reply Like
    • Marc Paige  I believe double and text columns are excluded from the list.  Not sure if that is what you are referring to or not.

      Reply Like
    • Steve Liebermensch Yes, that is exactly the answer I got from Dan.

      Reply Like
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 4Replies
  • 44Views
  • 3 Following