从两个表中选择 [英] select from two table

问题描述

表t1



项目---仓库

0 ----------- 11
0 ----------- 12

1 ----------- 11

1-- --------- 12

2 ----------- 11

2 ---------- -12





表t2



项目---仓库 - --product --- qty

0 ----------- 11 ------- 22 -------- 5

1 ----------- 12 ------- 23 -------- 6

2 -------- --- 11 ------- 24 -------- 7





结果

project --- godown --- product --- qty

0 ----------- 11 ------- 22 ---- ---- 5

0 ----------- 12 ------- 22 -------- 0

1 ----------- 11 ------- 23 -------- 0

1 ---------- -12 ------- 23 -------- 6

2 ----------- 11 ------- 24-- ------ 7

2 ----------- 12 ------- 24 -------- 0

解决方案

我希望您的问题可以通过SQl Inner Join解决，有关详细信息，请参阅此 sql_join_inner的.asp < br $>


和

 SELECT Project，Godown，Product，Qty 
 FROM Table1 A 
 INNER JOIN Table2 B 
 ON A.Project = B.Project.id 

  SELECT  
 t1.project，
 t1.godown，
 t2.product，
 t2.qty 
  FROM  t1 
  LEFT   JOIN  t2  on  t2.project = t1.project  AND  t2.godown = t1.godown 
  ORDER   BY  t1.project，t1.godown 

应该是你的解决方案。

试试这个： -

  SELECT  t1.project ，t1.godown，t2.product，t2.qty  FROM  t1 
  INNER   JOIN  t2   t1.project = t2.project  AND  t1.godown = t2.godown 

Table t1

project---godown
0-----------11
0-----------12
1-----------11
1-----------12
2-----------11
2-----------12


Table t2

project---godown---product---qty
0-----------11-------22--------5
1-----------12-------23--------6
2-----------11-------24--------7


Result
project---godown---product---qty
0-----------11-------22--------5
0-----------12-------22--------0
1-----------11-------23--------0
1-----------12-------23--------6
2-----------11-------24--------7
2-----------12-------24--------0

解决方案

I hope your problem solve with SQl Inner Join, for more information read this sql_join_inner.asp

and

SELECT Project, Godown,Product,Qty
FROM Table1 A
INNER JOIN Table2 B
ON A.Project = B.Project.id

SELECT
  t1.project,
  t1.godown,
  t2.product,
  t2.qty
FROM t1
LEFT JOIN t2 on t2.project =  t1.project AND t2.godown = t1.godown
ORDER BY t1.project, t1.godown

Should be your solution.

try this:-

SELECT t1.project,t1.godown,t2.product,t2.qty FROM t1
INNER JOIN t2 on t1.project = t2.project AND t1.godown = t2.godown

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