How To Make Multiple queries On One Data Report

[L1nuxVb]

Hi there, I Want To Design A Data report, So I Added A data environment & Data report , Created A Connection & Command1, in Command1 I Use SQL Query, So I need To Get Multiple Values From Different Tables,So:
i write An SQL Query:
SELECT * FROM students WHERE (SName = ?)
So I Can bound the result to textboxes on the report, but i need also to bound other results from different queries,
i tried to make another command, but the problem is that the data report is taking on command a once ,
wish to find an answer,

[anguswalker]

A query can select multiple values from different related or unrelated tables. e.g.

Select student.*,grades.* from students inner join grades on students.IDnum= grades.StudentID