Can you use Subtables with Existing database?

[Sorry_Duh]

Thinking in sub tables

Sorry, late to the show (again) but think this is important Sub tables and joins work differently and therefore their output is not the same so in some cases joins are appropriate, others sub tables So if i take a simple users table (this is from the sample data in docker) and I add to it a sub table of role [image] Now to illustrate the difference i now add a separate role table [image] Both role tables have the same content, two roles “A” and “E” attached to user id = 1 I then create tw…

Here’s the explanation