Hi,

OK i can also prefer sys.objects, But situation is this, the user should not be given with the grant view any definition permission, but he needs to access...

table -1

vijay BE ECE

table-2

vijay ECE ...

Using the left join i can achieve only one record... but i want two more record respect to the values 'B' and 'C' in the table-2

As my table has 1000 above entries with 3 various languages, i expects a generic solution to join this, not only for this example table

Kindly look at the newly modified post

i am meaning to say that the query has to fetch the values for the all column in the column list with the language_id as NULL

for ex:

slno ...

I think this would be perfect:

select isnull(x.eno,c.eno),x.ano,x.bno,c.no

from (select isnull(a.eno,b.eno) 'eno',a.no 'ano', b.no 'bno'

from ep1 a full outer join ep2 b

on (a.eno=b.eno)) x full outer join ep3 c

on (x.eno=c.eno)

order by 1

Regards

Vijayakumar...