How display Datagrid two different column value joining with same Master table

[Naresh Mehta]

I have tabel Details table contain field1 and field2 both having value of Master table id and text, now how display this value in datagrid.

e,g

Master Table               Details Table                                  Result Need in Datagrid
Id           Text              Field1       Field2

1            John                 1             2                                 John          Embross       
2            Embross           2             1                                 Embross     John 
3            Peter                3             1                                 Peter          John       

if I have change in select command pls. help me
my sql is select * from details where field1= id and field2 = id but it is not giving me any value.


Naresh

   

[thecyberzone]

Just use following sql as query ...

select b.Text as field1detail,c.Text as field2detail from Details a
left join Master b on a.field1 = b.Id
left join Master c on a.field2 = c.Id

Have a check.