Hello All,
This is the qury i needed.
select n.namefield , a.addessfield from NameTable a LEFT OUTER JOIN AddressTable b on a.userid=b.userid and a.company=b.company;
This is the mapping
NameTable entity
------------
AddressTable entity
----------------
But the query i got is,
SELECT t0.namefield,t1.addessfield FROM name_table t0 LEFT OUTER JOIN address_table t2 ON ((t2.company = t0.company) AND (t2.userid = t0.userid)), address_table t1
Can anyone please help me.
Thanks in advance