Hi Guys, I am having 2 table and I have joined the 2 tables. Say Table1 - Col_id, Col_OrderedByName, Col_Name_ProductName Say Table2 - Col_id, Col_ProductName My SQL: select t1.*, t2.* from Table1 t1 left join Table2 t2 on t1.col_Name_ProductName = t2.Col_id Problem: When I write this SQL in iReport designer, I am only getting the following columns Col_id, OrderedByName, col_Name_ProductName,Col_ProductName Now, i am missing Col_Id from Table2, is it possible to get Col_Id from Table2 without using Aliases. Regards Pradeep
