具有多个表的MySQL查询 [英] MySQL Query with Multiple Tables

问题描述

Table: UserInfoTbl
=======================
| username  | type    |
=======================
| user0001  | premium |
| user0002  | premium |
| user0003  | normal  |
| user0004  | premium |
=======================

Table: UserPvTbl
========================
| username | fUsername |
========================
| user0003 | user0002  |
| user0002 | user0001  |
| user0003 | user0001  |
========================

如何从UserInfoTbl中选择所有信息，其中UserPvTbl的fUsername的用户名为user0003?

How can I select all the information from UserInfoTbl where fUsername of UserPvTbl has username of user0003?

这意味着我需要从UserInfoTbl中检索user0002和user0001的信息

Meaning that I need to retrieve information of user0002 and user0001 from the UserInfoTbl

Edit2:两个表之间的关系:UserInfoTbl.username = UserPvTbl.username

Relationship between both tables : UserInfoTbl.username = UserPvTbl.username

推荐答案

DroidMatt您能否阐明两个表之间的关系是什么

DroidMatt can you clarify what the 2 tables relationship are

UserInfoTbl.username = UserPvTbl.fusername
或
UserInfoTbl.username = UserPvTbl.username

UserInfoTbl.username = UserPvTbl.fusername
or
UserInfoTbl.username = UserPvTbl.username

维克拉姆(Vikram)假设第一个是正确的.否则，你想要这个.

Vikram is right assuming the first. otherwise you want this.

SELECT *
FROM UserInfoTbl, UserPvTbl
WHERE UserPvTbl.username = UserInfoTbl.username
AND UserPvTbl.username = 'user0003'

这篇关于具有多个表的MySQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！