If I have a dataset with a bunch of datatables in it, is there a way I can execute a sql statement against the dataset?
Something like select a.id,b.name
from accounts as a
left join names as b on b.id = a.id
If so, can someone show me what is required to get this data from the dataset?