why use cross join in many sql query instead of join(inner join) ?

[DreamWuGit]

I saw many 'cross join' sql statement when composing sql query , from what I know , cross join statement with using condition will force sqlite query optimizer execute nested loop as join table order which occur in sql expression , is it because of this ? if there is any other concern ? appreciate your comments @tonyofbyteball @kakysha
Thnanks !

[tonyofbyteball]

Yes we want to ensure a specific order of tables, otherwise sqlite query planner often chooses suboptimal plans.

[DreamWuGit]

OK， Thanks for your feedback.

[DreamWuGit]

Closing it now.