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🔊 audiovalues.<right_qualified_column>: right-side qualified SQL column (TEXT) containing📝 text,🖼️ image, or🔊 audiovalues.<join_condition>:📝condition describing when two values should match.
Output semantics
- Returns
BOOLEANfor each candidate pair. - Intended for semantic join predicates in
WHEREclauses.
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.