#31 Duplicate Name Exception

open
nobody
None
5
2006-04-06
2006-04-06
Fylom
No

The following valid SQL query generates an exception
from MySQLDriverCS :

"SELECT `table1`.`info1`,`table2`.`info1`,`info2` FROM
`table1`, `table2` WHERE `table1`.`info1` =
`table2`.`info1` AND `info2` = 'xyz'";

The exception description is:

"System.Data.DuplicateNameException: A column
named 'info1' already belongs to this DataTable."

The query has been successfully tested using
phpMyAdmin.

Discussion

  • Fylom
    Fylom
    2006-04-06

    SQL script to create a test database and tables with values

     
    Attachments