Question

Which of the following is the correct syntax for an INNER JOIN in SQLite?

a) SELECT columns FROM table1 INNER JOIN table2 ON condition

b) SELECT table1 FROM columns INNER JOIN table2 ON condition

c) SELECT columns FROM table1 JOIN table2 ON condition

d) None of the above

Answer 1

Answer: a) SELECT columns FROM table1 INNER JOIN table2 ON condition

Explanation: The correct syntax for an INNER JOIN in SQLite is SELECT columns FROM table1 INNER JOIN table2 ON condition.