I am trying to get my head around dataset merging but despite a little
research I could still use a pointer (or ten). Basically I want to perform
an outer join operation on a dataset (created from a file operation) and the
resulting sql query based on the contents of said dataset. Effectively I
would end up with two dataset tables in my application. If I were writing
this to action from two tables it would be thus:

SELECT ds.id, db.*
from
dataset ds LEFT OUTER JOIN
database db on db.field1 = ds.id

such that I retain the original dataset items. I have read something about a
dataset relationship but I do not see how this achieves the all-inclusive
results I am after.

any insight much appreciated :-)

n