数据库作业：第三章课后题

第三题
1 .

    select *  
          from S 
          where A=10;

2
.

select A,B
      from S；

3 .

select  A,B,S.C,S.D,E,F  
     from S,T
      where S.C = T.C and S.D =T.D

4

  select A,B,S.C,S.D,T.C,T.D,T.E,T.F 
         from S,T  
         here S.C=T.C;

5
.

select * 
        from S,T 
     where A<E;

. 6

select S.C,S.D,T.C,T.D,T.E,T.F 
       from S,T;

第四题
1 .

select distinct SNO
       from SPJ
       where jno ='J1'

2
.

select distinct SNO
        from SPJ
        where JNO ='J1' and PNO ='P1';

 select distinct Sno
  from