如何从两个不同的表中访问第一行数据？ [英] How to access first row data from two different table?

问题描述

我有两个表问题和回答

问题

~~~~~~~~

id name question

----------------------------

1 name1什么是java？

2 name2什么是c？





回答

~~~ ~~~~

id answer1 answer2

-----------------------

1 ans1 ans2

2 ans3 ans4



i想要访问这样的第一行数据



id name question answer1 answer2

---------------------------- --------- ----------

1 name1什么是java？ ans1 ans2



我尝试了什么：



如何先访问来自两个不同表的行数据？

查询是什么？

i have two table "question" and "answer"
question
~~~~~~~~
id name question
----------------------------
1 name1 what is java?
2 name2 what is c?


answer
~~~~~~~
id answer1 answer2
-----------------------
1 ans1 ans2
2 ans3 ans4

i want to a access first row data like this

id name question answer1 answer2
------------------------------------- ----------
1 name1 what is java? ans1 ans2

What I have tried:

how to access first row data from two different table?
what is query for this ?

推荐答案

SELECT q.id, q.name ,q.question,a.answer1, a.answer2
FROM question q
INNER JOIN answer a 
ON a.id =  q.id where q.id =1 

参考 SQL INNER JOIN关键字 [ ^ ]

这篇关于如何从两个不同的表中访问第一行数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！