"The query is executed against one or more tables specified after the FROM keyword. If multiple tables names are separated by commas, then the query is against the cross join of the various tables. The full SQL-92 join syntax can also be used to specify joins. A sub-query in parentheses may be substituted for any table name in the FROM clause. The entire FROM clause may be omitted, in which case the result is a single row consisting of the values of the expression list."
Autrement dit, SQLite supporte les jointures entre tables. Le contraire aurait été inquiétant :o). Par ailleurs, SQLite supporte aussi les vues (en lecture uniquement), les jointures externes gauche, certaines sous-requêtes, etc... (cf doc).
[^] # Re: Access ne me manque pas
Posté par Papey . En réponse à la dépêche Ne vous demandez pas ce que Kexi peut faire pour vous.... Évalué à 3.
http://www.sqlite.org/lang.html#select(...)
"The query is executed against one or more tables specified after the FROM keyword. If multiple tables names are separated by commas, then the query is against the cross join of the various tables. The full SQL-92 join syntax can also be used to specify joins. A sub-query in parentheses may be substituted for any table name in the FROM clause. The entire FROM clause may be omitted, in which case the result is a single row consisting of the values of the expression list."
Autrement dit, SQLite supporte les jointures entre tables. Le contraire aurait été inquiétant :o). Par ailleurs, SQLite supporte aussi les vues (en lecture uniquement), les jointures externes gauche, certaines sous-requêtes, etc... (cf doc).