Q: How can I achieve related query for two datasets?
A: In SQL query, select Related in the field list, select two common fields from the two datasets to relate them in the dialog box that pops up. After the association, click Add and you can see the related field in the field list, which enables you to achieve related query for the two datasets.