1) SELECT a.RNO, a.Name, b.Institute, b.Phone
FROM tblReader a left outer join tblSubscription b on a.RNO=b.RNO
Where a.RName like '%임%'
2) SELECT a.RNO, a.Name, b.Institute, b.Phone
FROM tblReader a left outer join tblSubscription b on a.RNO=b.RNO
And a.RName like '%임%'
|