Zandbak/Sub-zandbak3: verschil tussen versies

Uit Inf2019
Naar navigatie springen Naar zoeken springen
Regel 2: Regel 2:


{{#cargo_query:  
{{#cargo_query:  
tables=Books,Authors  
tables=Books,Books_Authors, Authors  
|join on=Books.Authors HOLDS Authors._pageName  
|join on=Books._ID=Books__Authors._rowID, Books__Authors._value=Authors._pageName
|fields=Books._pageName, Books.Authors, Authors._pageName, Authors.Country
|fields=Books._pageName, Books.Authors, Authors._pageName, Authors.Country
|order by=Authors._pageName
|order by=Authors._pageName
}}
}}

Versie van 3 jul 2022 20:18

Database (Cargo) queries

Error: table "Books__Authors" is not in list of table names or aliases.