I have a script that cross joins about 4 tables:
SELECT * FROM Districts CROSS JOIN Seasons CROSS JOIN Sectors CROSS JOIN Sites
The above query will combine all the tables into one, see a sample picture: I want to add two more tables Group and Client, but not the entire tables, just the COUNT of both tables. so after the print column in the picture below, there should be two more columns, GroupCount for group table count and ClientCount for client table count. How do I do it?