Query Rgearding Fetch data from multiple tables in ServiceStack ORMLite

**Problem Statement:**
The ORMLite framework in Azure Function with.NET 8 is what we're using to fetch data from multiple tables using SQL joins and select into a single model. However, when I run this query, the only table that returns is NoteTemplateFolders, even though I want the data from every table that I select in the SQL expression.

Please provide guidance and possible solutions for the above mentioned scenario.

**My Code:**
```csharp
SqlExpression sqlExpression = _tenantDatabase.From()
.Join((folder, template) => folder.Id == template.FolderId)
.Where(x => x.Name == "Template 342079")
.Select((folder, template) => new
{
FolderId = folder.Id,
FolderName = folder.Name,
Id = template.Id,
Name = template.Name,
ClientName = "Test"
});

List response = _tenantDatabase.Select(sqlExpression);
```