Operator: AIJOIN

Syntax: AIJOIN(<left_qualified_column>, <right_qualified_column>, '<join_condition>')

Parameters

• <left_qualified_column>: left-side qualified SQL column (TEXT) containing 📝 text, 🖼️ image, or 🔊 audio values.
• <right_qualified_column>: right-side qualified SQL column (TEXT) containing 📝 text, 🖼️ image, or 🔊 audio values.
• <join_condition>: 📝 condition describing when two values should match.

Output semantics

• Returns BOOLEAN for each candidate pair.
• Intended for semantic join predicates in WHERE clauses.

Columns containing text, images, or audio files always use SQL type TEXT. Images and audio files are encoded as text and automatically recognized by GesamtDB.

Example

SELECT *
FROM ProductDB1 P1, ProductDB2 P2
WHERE AIJOIN(P1.productName, P2.productName, 'this is the same product');

Tips

• Add standard SQL join predicates where possible (for example, category/date filters).
• Keep join conditions specific and unambiguous.