In the SQL statement when creating a recordset query in Data Bindings...is there a way to call or declare a recordset query that is listed in the data bindings list you've just created, as opposed to tables from a database?

Example: In Data Bindings, I just created a recordset called "Trailers" that uses a table from the database called tblTrailers. I want to create a new recordset query in Data Bindings that will call the query "Trailers" and NOT tblTrailers. My SQL should read:

SELECT Sum(LeaseRate)
FROM Trailers

*Notice how I want FROM to call the listed query in Data Bindings as opposed to a table in my database connection...Is this possible and how can I do it?

You can go about this 2 ways. The first way is to create a View or Query that is stored in your DB and call on it that way. The second way is to nest your queries, ie, a query inside of a query. That can get complex if you are a novice at writing SQL statements.

Thanks for replying...can you show me an example of a nested query in SQL? Keep in mind I'm using MySQL as my database...

SELECT SUM(tblEmpName.rate * (timesheet.[Administrative Hours] + timesheet.[Coding hours])) AS TotalRate FROM dbo.tblEmpName INNER JOIN dbo.timesheet ON timesheet.Personname = tblEmpName.Name WHERE timesheet.[Case Name] = 'Pogue'