8.18. How do I perform multi-table SQL queries and/or joins using dot notation?
(Answered by Mike Heins)
Example question: "How come I can't use [sql-param tablename.fieldname] notation when I do a multi-table query?"
DBI simply does not support tablename.fieldname in the return value.
You can just refer to them by the fieldname. In the case of field names that are the same but need to be selected from different tables, you can use "SELECT orderline.quantity as o_quan,..." and refer to it as [sql-param o_quan].