Hi all, trying to join 2 tables with a unique ref in each - easy.
However, in 1 table its a char field and in the other its an integer. For various reasons I can't change either column type. Now when I try and turn the int into a char by using Str$() or vice versa by using Val() I get the old "invalid join in where condition" statement!! Any ideas about how to join these two in an SQL statement. Regards, Nick Hall Salford GIS Ltd --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10435
