PolarDB-X 1.0 supports most join syntax. Some limits are specified for complex scenarios in PolarDB-X 1.0. For example, joins between large tables may result in performance or system unavailability due to the high cost and the slow speed. Therefore, do not perform such joins if possible. For more information, see Optimize and execute JOINs and subqueries.