I have a parent table that has three child records related to it. I need to grab a field from the parent table and four fields from each of the child records into ONE record(it will have 13 fields, one from the parent and 4 from each of the child records). I think it should be some type of UNION, but I can't figure it out. Any help would be greatly appreciated.


Shane