Go Beyond VFP's SQL with SQL Server and MySQL

This was presented by Tamar Granor at Virtual Fox Fest 2024: https://virtualfoxfest.com The subset of SQL in Visual FoxPro is useful for many tasks. But there's much more to SQL than what VFP supports. Those additions make it easy to do a number of tasks that are difficult in VFP. In this session, we'll solve some common problems, using SQL elements that are supported by SQL Server and MySQL, but not by VFP. Among the problems we'll explore are combining a set of values contained in multiple records into a delimited list in a single record, working with hierarchical data like corporate organization charts, finding the top N records for each group in a result, and including summary records in grouped data.