Value in master table retrieved using key to detail table

[Laura]

Would I be able to get an example of the following:

I have a master table called contacts. One field is contact_type_id. In the master table I would like to display the contact_type_name which resides in the contact_type table. So rather than just displaying the contact_type_id which is in the master contacts table, I would like to show the name of the contact type to be more explicit.

Thanks in advance,
Laura

[Shinu]

Hi Laura,

If the data resides in different datatables, you can use a join/union clause in your select statement and then include the resulting fields in the RadGrid.

Thanks
Shinu

[rtk]

Is there a way to do this without joining the tables in sql.

My datalayer only allows me to get one datatable with contact_id and one datatable with contact_name. Can i put this to datatable in a dataset and join them there?? And somehow display the name instead of the id in the grid.