查询以获取有关用户的信息 [英] querry to get information about user

问题描述

我有两个表t1和t2

t1具有三个字段
f1，f2，f3，其中f1是主键

和t2具有三个字段
f1，fb，fc，其中f1是外键



现在要从f1和fb中获取f3

我该怎么做

i have two tables t1 and t2

t1 has three fields
f1, f2, f3 where f1 is primary key

and t2 has three fields
f1, fb, fc where f1 is foreign key



now from f1 and fb i want to get f3

how i have to do

推荐答案

SELECT t2.f3 FROM t2
INNER JOIN t1 ON t1.f1 = t2.f1
WHERE t1.fb = 'value'

进一步了解

Read more about JOINS[^].

根据我对您的理解(不完整，不清楚)，问题:

From what I understood from you (incomplete, unclear) question:

SELECT
    T2.F3
FROM T1 INNER JOIN T2 ON
    T1.F1 = T2.f1
WHERE
    T1.F1 = 'whatever'
    AND T2.Fb = 'I do not care'

这篇关于查询以获取有关用户的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！