如何在sql中将多个查询组合到单个查询中 [英] how to combine multiple query to single query in sql

问题描述

嗨


我有两张桌子

名字：第一和第二

表：第一张

ID name

1 aaa

2 bbb

表：秒

ID name

1 aaa

2 ccc

3 ddd

4 eee



现在我要结合像



fname sname

2 4



输出显示相应表格中的行号。

任何建议请................！

解决方案

  SELECT （ SELECT  COUNT（ID）  FROM  first） AS  fname，
（ SELECT  COUNT（ID） FROM  second） AS  sname 

做一些学习TSQL，它会很有用。



你还没有定义连接标准，所以我将假设ID

 选择 first.name 作为 FName， second.name  as  LName 
  From  first f 
 内部 加入第二个  s.ID = F.ID 

hii prabhatsp



尝试这个，我试过成功运行...回复

 SELECT 
（SELECT COUNT（*）FROM FIRST）AS fname，
（SELECT COUNT（*）FROM SECOND）AS sname; 

Hi
I have two table
name: first and second
Table: first
ID name
1 aaa
2 bbb
Table: second
ID name
1 aaa
2 ccc
3 ddd
4 eee

Now i want to combine like

fname sname
2 4

The output show the no of row in corresponding tables.
Any suggestions pls................!

解决方案

SELECT (SELECT COUNT(ID) FROM first) AS fname,
       (SELECT COUNT(ID) FROM second) AS sname

Do some learning about TSQL, it will be of great use.

You have not defined the join criteria so I'll assume the ID

Select first.name as FName, second.name as LName
From first f
inner join second s on s.ID = F.ID 

hii prabhatsp

Try this ,i tried run successfully...reply

SELECT 
(SELECT COUNT(*) FROM FIRST) AS fname,
(SELECT COUNT(*) FROM SECOND) AS sname;

这篇关于如何在sql中将多个查询组合到单个查询中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！