如何在sqlite3中同时搜索多个表？

-- 创建示例表
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL
);

CREATE TABLE orders (
    id INTEGER PRIMARY KEY,
    user_id INTEGER,
    product TEXT NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 插入示例数据
INSERT INTO users (name) VALUES ('Alice');
INSERT INTO users (name) VALUES ('Bob');
INSERT INTO orders (user_id, product) VALUES (1, 'Book');
INSERT INTO orders (user_id, product) VALUES (1, 'Pen');
INSERT INTO orders (user_id, product) VALUES (2, 'Notebook');

-- 使用INNER JOIN搜索多个表
SELECT users.name, orders.product
FROM users
INNER JOIN orders ON users.id = orders.user_id;