That's a bug. Report it. Try moving the join condition into a WHERE clause: SELECT GCMCL.* FROM GCMCL, LINFAC WHERE GCMCL.CODIGOTXT = LINFAC.CODCLI;
If that doesn't work, try a CAST: SELECT GCMCL.* FROM GCMCL, LINFAC WHERE CAST(GCMCL.CODIGOTXT AS VARCHAR) = CAST(LINFAC.CODCLI AS VARCHAR); But do report it. ----- Original Message ----- From: "Cisar Riba Cervera" <[EMAIL PROTECTED]> To: [email protected] Subject: [U2] Error in sentence SQL Date: Mon, 5 Sep 2005 12:00:18 +0200 > > Hello > > I recive this error when I execute this sentece SQL > > > SELECT GCMCL.* FROM GCMCL INNER JOIN LINFAC ON GCMCL.CODIGOTXT = > LINFAC.CODCLI; > UniVerse/SQL: number and character types are incompatible in this > operation > Scanned command was FROM GCMCL INNER JOIN LINFAC ON GCMCL.CODIGOTXT = > LINFAC.CODCLI SELECT > > The fields DICT for the two fields are: > > >ED DICT GCMCL CODIGOTXT > 8 lines long. > > 0001: D > 0002: 0 > 0003: > 0004: COD_CLI > 0005: 6L > 0006: S > 0007: > 0008: VARCHAR,6 > > >ED DICT LINFAC CODCLI > 8 lines long. > 0001: D > 0002: 10 > 0003: > 0004: > 0005: 6L > 0006: S > 0007: > 0008: VARCHAR,6 > > > Can help me. > > Tanks > > Best Regarts > > Cisar Riba Cervera > Spain > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.344 / Virus Database: 267.10.18/89 - Release Date: 02/09/2005 > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
