Hi,

Thanx for the response. What I was confused was the way the data is retrieved, like these queries return the same record

select x.*  from tbl1 X

left outer join ...