Pull Request for Issue # .

Summary of Changes

Fix the SQL update statement from PR #35164 for certain older MySQL or MariaDB versions.

Use (almost) the same changes also for PostgreSQL because it's better SQL.

CROSS JOIN is supported on MySQL 5.6. so it is ok for Joomla 4.

On PostgreSQL it is supported too, but not in UPDATE statements, it seems, therefore the slightly different syntax for PostgreSQL.

Testing Instructions

1. Update from 3.10 to 4.0 using a new package which includes the merged PR #35164 .
   You can build a package with following command:
   php ./build/build.php --remote=HEAD --exclude-gzip --exclude-bzip2
   Result: See section "Actual result BEFORE applying this Pull Request" below.

2. Do the same again but use the update package built by drone for this PR.
   Result: See section "Expected result AFTER applying this Pull Request" below.

Actual result BEFORE applying this Pull Request

On certain older MySQL (5.7 in my case) or MariaDB versions:

On newer versions of MySQL or MariaDB and on PostgreSQL there is no such error.

Expected result AFTER applying this Pull Request

No such SQL error on any supported database version.

Documentation Changes Required

None.