SQL JOIN output question

  1. 6 months ago

    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.

  2. Ivan T

    Jan 6 Pre-Release Testers Answer
    Edited 6 months ago

    What do you mean with datalist?

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

  3. Edited 6 months ago

    Exactly what I was hoping for. Thanks!

or Sign Up to reply!