is related multiple fields supported?

i have 2 tables, one is to store multiple results keyed to the other table:

table 1:
pid
query

table 2:
pid
type

table 1 has 1 entry with a given pid, table 2 has many entries per pid.

This would be similiar to having a cck field that supports multiple.

In the CCK case i would be able to set the field (type, in this example) in the view as grouped so that i would see all the entries for type in the row for pid. Actually i think i get option to either create a row per type or have them grouped.

is this supported somehow in TW?