Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

求问超级简单的数据表查询如何写

WBOY
Release： 2016-06-13 12:08:30
Original
1030 people have browsed it

求问超级简单的数据表查询怎么写？
表A字段：id  title  text

表B 字段：id Aid  

表A的id 存为表B的Aid。

查询出表B的 Aid，然后再通过Aid查询出表A的title  ，直接写出一句SQL，怎么写？
------解决思路----------------------

selcet * from A where id IN (select Aid from b);
Copy after login

不知道是不是你想要的。
------解决思路----------------------
select B.Aid,A.title from B join A on B.Aid=A.id
------解决思路----------------------
select A.title from A,B where A.id=B.Aid 

Related labels：
from nbsp select title
source：php.cn
Previous article：简易的mysql管理程序 Next article：PHP Session 变量的使用方法详解与范例代码（转）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1284
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template