mysql - 使用得到的结果集再次查询

Question

在下面的查询中，我想使用ii.instanceId(在下面的查询中)从另一个表instanceinfo获取ipAddress。

Select ui.userId, ui.username, ui.userStatus, ui.organization, ii.instanceId from 
userinfo as ui left join instanceallotmentinfo as ii on ui.accountId = ii.accountId 
where userType != 4 AND userId != 1 order by userId asc LIMIT 0 , 10

获得ipAddress后，我想通过ipAddress列查看上述查询的集体结果。我怎样才能做到这一点？

Answer 1

您可以使用多个联接来查询数据库，如下所示:

Select ui.userId, ui.username, ui.userStatus, ui.organization,  iai.instanceId, ii.instanceIpAddress from 
userinfo as ui 
left join instanceallotmentinfo as iai on ui.accountId = iai.accountId 
left join instanceinfo as ii on ii.instanceId = iai.instanceId;