SQL JOIN output question

Good evening,
I am starting to experiment with writing sql queries using the JOIN method, using data from two different tables that share a common column of data.

The hopefully very basic question I have… can the results of the Sql JOIN command in Xojo be shown in a single datalist?
Or is there an underlying rule that each datalist be constrained to one table?

If it is possible, appreciate a point in the right direction.

If not, what do others use as alternatives for displaying the data?

Thanks,
John

What do you mean with datalist?

The recordset returned by the SQL JOIN it behaves like a single table.

Exactly what I was hoping for. Thanks!