I use a MariaDb database when I use the JOIN clause
scriptcase does not recognize the type of DATETIME field, not allowing you to use search functions by date.
[SIZE=16px]Attention: Your field type is Date/Time, but the SQL type in the database is not: DATE, TIME, DATETIME or TIMESTAMP.[/SIZE]
[SIZE=16px]Therefore the blocks “Field Behavior” and “Special Conditions” cannot be configured at this time[/SIZE]
SELECT
ma.Codice,
ma.DataOraArrivo
FROM mio_trasmissioniAE ma
LEFT JOIN SitCli sc ON sc.Codice=ma.codsito
If I omit the JOIN clause, the date field is correctly recognized as the DATETIME field