General information
Category:
Coding, syntax & commands
Simply join the two tables and in turn, make sure fields from the parent and child are in the select list
Select parent.field1, parent.field2, child.field1, child.field2, child.field3
From parent
Join child On (parent.pk = child.fk)
This would give you a starting point. Then you could post-process the result set and append the data into a fabricated cursor with a memo field.
It cannot be done with SQL alone.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only