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?