multiple column with same name

[pradeepcalls]

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

[rsuddhala]

Hi Pradeep,

Insted of t1.* or t2.* write all column names you will get  example

 

select  t1.Col_Id, t2.Col_Id,t1.OrderedByName  from Table1 t1 left join Table2 t2 on t1.col_Name_ProductName = t2.Col_id

[ybablyuk]

Hello, query should be like this

select  t1.Col_id as t1_col_id, t1.Col_OrderedByName, t1.Col_Name_ProductName,  t2.Col_id as t2_col_id, t2.Col_ProductName from Table1 t1 left join Table2 t2 on t1.col_Name_ProductName = t2.Col_id

[pradeepcalls]

Thanks  for your kind response.