您应该在两个表上使用join来从两个表中获取匹配的值，但是当您需要来自tasklist的值时.你可以做这样的事情，

You should use join on both tables to get matching values from both tables but as you need values from tasklist. You can do something like this,

      Select tasklist.*,netstat.address 
      From tasklist join netstat
       On tasklist.pid = netstat.pic and tasklist.hostname = netstat.hostname