I am trying to join 2 tables.. a User table and a States table. They are related via "stateID" and "fkStateID" and the field is an integer.
Recently, someone from another country joined and since they do not have a state, the state field is blank (not NULL). This is causing joins (including outer joins) to fail with the error ... "Error converting data type varchar to numeric."
I have considered adding a none option to the states table, and then using that to populate the User table with a value, but that seemed a little messy. Is there another, better alternative?