What's the general rationale for splitting related data into multiple ... a separate table with records for each ticket, which you could then derive total ticket count via SQL.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

I'm trying to parse a single record row so that I get a record set of multiple values formatted into two fields, i.e. so that I can then use these values in two joins to two other tables ...

The basic Server Extensions that ship with UltraDev allow you to issue SQL INSERT statements, but only to one table. In many cases, you may need to insert data to multiple tables at the same time ...