Re: Table alias in results map.

2006-03-29 Thread Jeff Butler
Short answer - no.   Only the column name is returned in the result set.  This is JDBC, not just iBATIS.  Run the query in something like the Squirrel SQL client to verify.   A better solution would be to use a real domain object instead of a map, and use iBATIS' group by and descriminator support.

Table alias in results map.

2006-03-29 Thread Daniel Pitts
I want to perform a query like: Select * FROM data AS `root:data` JOIN other AS `root:other` JOIN something as `root:other:something` WHERE $where$ The tables "data", "other", and "something" may or may not have similarly named columns. The aliases correspond to bean's in a map. ---CODE--- Map