Just an FYI on Using Certain SQL Syntax with Make. Wildcard '*' selects do not work with a table name as the prefix... Just an FYI on Using Certain SQL Syntax with Make

For anyone doing SQL queries…

This is just an FYI that when querying from multiple tables it appears that you cannot use the wildcard ‘asterisk’ to select all columns in a table. After some effort and non-helpful error messages, I realized that I had to replace Trip.* with the names of each individual column.

I hope this helps someone!! Also, there is no ‘tag’ for ‘sql’, so I picked ‘mysql’, but the actual server is Azure SQL Server.

Likewise, the AI assistant was not much help, nor was ChatGPT.

Paul

SELECT
Trip.*,
TripStatus.ENUM AS TripStatusEnum,
Company.CompanyName,
DistanceUOM.DistanceUOM AS DistanceUnit,
ReservationType.ReservationType AS ReservationTypeName
FROM
[dbo].[Trip] AS Trip…