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…