mysql - 试图从 3 个不同的表中找到 3 列

Question

我有以下 3 个表：

CREATE TABLE Pins (
    email varchar(100) NOT NULL,
    boardID int NOT NULL,
    ));

CREATE TABLE Boarders (
    email varchar(100) NOT NULL,
    boardID int NOT NULL,
    FOREIGN KEY (categoryName) REFERENCES Category (name));


CREATE TABLE User (
    email varchar(100) NOT NULL,
    name varchar(50),
    PRIMARY KEY (email));

我想让查询搜索结果是这样的：对于每个 Pin，显示描述

这显然是行不通的，但是关于如何显示上述内容的任何建议？

标签： mysqlsql

Answer 1

select p.description ,c.title, u.name from PushPin p,CorkBoard c, User u
    where c.email=u.email and c.email =p.email  and c.boardID = p.boardID 
      order by p.description