oracle pl/sql 查询

Question

编写 SQL 语句保存为 .sql 文件运行，查询各城市的客户和供应商，查询结果包括：城市、公司名称、联系人姓名、关系
这个要怎么写啊

Answer 1

select 城市、公司名称、联系人姓名、关系 from ...............

Answer 2

create table Customer
(
    CusID                       varchar2(5),
    FirmName                 varchar2(40),
    ConnetName                varchar2(30),
    Connetduty                varchar2(30),
    Address                   varchar2(60),
    City                   varchar2(15),
    Area                   varchar2(15),
    PostCode                 varchar2(10),
    State                   varchar2(15),
    Phone                   varchar2(24),
    Fax                   varchar2(24)
);
create table Supplier
(
    SupplierID                NUMBER         not null,  
    SFirmName                VARCHAR2(40),
    SConnetName                VARCHAR2(30),
    SConnetduty                VARCHAR2(30),
    SAddress                  VARCHAR2(60),
    SCity                   VARCHAR2(15),
    SArea                   VARCHAR2(15),
    SPostCode                 VARCHAR2(10),
    SState                   VARCHAR2(15),
    SPhone                  VARCHAR2(24),
    SFax                  VARCHAR2(24),
    SHomePage            VARCHAR2(100)
);
没有 关系 这个列  要自己判定