| empnumber
| projectid
| name
|
| A001
| P001
| 中田
|
| A002
| P002
| 中村
|
| A003
| P003
| 小野
|
| A002
| P004
| 中村
|
| A002
| P005
| 中村
|
| A002
| P006
| 中村
|
|
| projectid
| workhour
|
| P001
| 10
|
| P002
| 20
|
| P003
| 30
|
| P004
| 40
|
|
select *
from EmpProject as A left outer join Work as B on A.projectid=B.projectid
where A.empnumber = 'A002'
| empnumber
| projectid
| name
| projectid
| workhour
|
| A002
| P002
| 中村
| P002
| 20
|
| A002
| P004
| 中村
| P004
| 40
|
| A002
| P005
| 中村
| NULL
| NULL
|
| A002
| P006
| 中村
| NULL
| NULL
|
select *
from EmpProject as A left outer join Work as B on A.projectid=B.projectid
where A.empnumber = 'A002' and B.workhour > 25
| empnumber
| projectid
| name
| projectid
| workhour
|
| A002
| P004
| 中村
| P004
| 40
|
select *
from EmpProject as A left outer join Work as B on A.projectid=B.projectid and B.workhour > 25
where A.empnumber = 'A002'
| empnumber
| projectid
| name
| projectid
| workhour
|
| A002
| P002
| 中村
| NULL
| NULL
|
| A002
| P004
| 中村
| P004
| 40
|
| A002
| P005
| 中村
| NULL
| NULL
|
| A002
| P006
| 中村
| NULL
| NULL
|
Tools 
