how to deal join tables query

[lifejoyforpy]

hi,i found the example is only a table curd,in actual . many interface include many tables join .i hope you help me .howto deal ths
scenario。