Hi all, am trying to select information from a few tables, and because some of the tables have overlapping fieldnames e.g. name etc, I am trying to reference them in my sql statment like this... sqlString = "select myTable1.name, myTable2.name from myTable1, myTable2 where .... and so on and so on this unfortunately does not work and I am told that 'column not found' My question is can fields be referenced by their table name? If not, how can specific tables be referenced in a similar way if they have different schemas? By the way my connection is with the JDBC DBC bridge.... could the bridge be my problem.
I don't see anything wrong with your partial SQL statement. Make sure your column is really "name" and not "Name" or "NAME". Column names are case sensitive. Also, try quering a sinle table and see if you get the same error message. If all this failes, show us your complete SQL statement followed by the complete error message. Sometimes those error messages aren't for the reasons you think.
U have to have consistent aliasing of the column names. In you where clause u should prefix the column with the 'tablename.' in the last instance where u had success, there were no aliases used, and by default all the columns were 'bound' to the table in the FROM part of the sql statement.