how to add column from parent table?

[dario]

i have a dataset with two tables (parent/child) and i display CHILD table in
datagrid. i'd also like to display PARENT.NAME besides parent ID in the
CHILD datagrid. parent name is, of course, in the parent table, and i have
parent ID as foreign key in the CHILD table. All child columns are
displayed, i just need to ad one column with related data from parent table.
datagrid is not going to be used for edit, so it just needs to display text
from parent table, no dropdowns or anything advanced.