How deep can I go in a select statement

Hi all I'm a newbie transistioning from FM and trying to wrap my head around how Ninox does things. First I have the following tables: Riders Results Teams Team Membership I'm working in Team…