从3table中获取数据 [英] fetching data from 3table

问题描述

这里我有代码从3个表中选择相同的地方数据在哪里条件我怎样才能简化这个

Here i have the code to select singna data from 3tables with same where condition how can i simplify this

SELECT SUM(SIGNA) FROM dbo.tblPLAG
WHERE   VERSION='ACTUAL' AND STATS='ST_Z010'
 AND FACILITY='FA_2003'
 AND  TD IN  ( SELECT TIMEID FROM Time   WHERE   ID BETWEEN
  @YEAR+'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD-6 AS varchar), 3))
 AND
@YEAR +'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD AS varchar), 3)))
union

SELECT SUM(SIGNA) FROM dbo.tblPLAG 1
WHERE   VERSION='ACTUAL' AND STATS='ST_Z010'
 AND FACILITY='FA_2003'
 AND  TD IN  ( SELECT TIMEID FROM Time   WHERE   ID BETWEEN
  @YEAR+'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD-6 AS varchar), 3))
 AND
@YEAR +'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD AS varchar), 3)))

union

SELECT SUM(SIGNA) FROM dbo.tblPLAG3
WHERE   VERSION='ACTUAL' AND STATS='ST_Z010'
 AND FACILITY='FA_2003'
 AND  TD IN  ( SELECT TIMEID FROM Time   WHERE   ID BETWEEN
  @YEAR+'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD-6 AS varchar), 3))
 AND
@YEAR +'.'+(SELECT RIGHT ('000'+ CAST (@PERIOD AS varchar), 3)))

推荐答案

Hai



最简单的方法是使用view，尝试在sql server中创建视图，如果你在sql中打开你的数据库，你可以看到数据库Didgrams，Tables，Views，Synonyms ..... upto Security。



只需右键单击视图--->新视图，打开一个窗口添加表，只需在该列表中选择3个表并单击添加，然后显示3个表，你只需用3个表创建相同字段的链接。如果你用3个表链接3个表，然后在3个表中选择你需要的字段，在下面的列表中显示3个表中你选择的字段ables，你可以在Filter.again旁边的Orcoloumn中添加条件beleow你会看到一个查询被形成，如果你执行那个查询你可以在下面得到结果，所以现在你得到单个数据形式3个表有相同的地方条件，只是复制该查询和过去在存储过程中使用dbo形成的查询。字符串，只需删除它，然后你可以得到清楚的查询形式。

Hai

The easiest way is use view,try to create view in sql server,if u open ur database in sql,u can see Database Didgrams,Tables,Views,Synonyms ..... upto Security.

Just Right Click Views--->New View,it open one windows "Add Table",just select 3 tables in that list and click add,then it show 3 table,just u create link with same fields with 3 tables.if u link 3 tables with unique column,then select what r the fields u need in 3 tables,below coloumn one appear with ur selected fields from 3 tables,and u can add condition in "Or" coloumn next to Filter.again beleow u will see one query is formed,if u execute that query u can get result at below,so now u get single data form 3 tables with same where condition,just copy that query and past in stored procedure.u r query formed with dbo. string,just remove it,then u can get clear form that query.

这篇关于从3table中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！