Rc39DcFv

1SELECT LastName
2    ,FirstName
3    ,BirthYear
4    ,LocalExp
5    ,TotalExp
6    ,TotSalary
7    ,TotFringe
8    ,WorkLocationName
9    ,SchoolName
10FROM DPISTAFF2008_2009
11    ,DPISTAFF2009_2010
12    ,DPISTAFF2010_2011
13    ,DPISTAFF2011_2012
14    ,DPISTAFF2012_2013
15    ,DPISTAFF2013_2014
16    ,DPISTAFF2014_2015
17    ,DPISTAFF2015_2016
18WHERE DPISTAFF2015_2016.FirstName = 'George'
19	
20CREATE TEMP TABLE IF NOT EXISTS _Variables (Name TEXT PRIMARY KEY, Value TEXT);
21INSERT OR REPLACE INTO _Variables VALUES ('VarFirstName', 'John');
22INSERT OR REPLACE INTO _Variables VALUES ('VarLastName', 'Smith');
23
24SELECT LastName,FirstName,BirthYear,(strftime('%Y', date('now')) - BirthYear) AS Age,LocalExp,TotalExp,TotSalary,TotFringe,WorkLocationName,SchoolName
25FROM DPISTAFF2008_2009
26WHERE DPISTAFF2008_2009.FirstName = (SELECT Value FROM _Variables WHERE Name = 'VarFirstName')
27    AND DPISTAFF2008_2009.LastName = (SELECT Value FROM _Variables WHERE Name = 'VarLastName')
28UNION ALL
29
30SELECT LastName,FirstName,BirthYear,(strftime('%Y', date('now')) - BirthYear) AS Age,LocalExp,TotalExp,TotSalary,TotFringe,WorkLocationName,SchoolName
31FROM DPISTAFF2009_2010
32WHERE DPISTAFF2009_2010.FirstName = (SELECT Value FROM _Variables WHERE Name = 'VarFirstName')
33    AND DPISTAFF2009_2010.LastName = (SELECT Value FROM _Variables WHERE Name = 'VarLastName')
34UNION ALL
35
36;DROP TABLE _Variables;
37	
38SELECT LastName
39    ,FirstName
40    ,BirthYear
41    ,LocalExp
42    ,TotalExp
43    ,TotSalary
44    ,TotFringe
45    ,WorkLocationName
46    ,SchoolName
47FROM DPISTAFF2008   
48WHERE FirstName = 'George'
49UNION ALL
50SELECT LastName
51    ,FirstName
52    ,BirthYear
53    ,LocalExp
54    ,TotalExp
55    ,TotSalary
56    ,TotFringe
57    ,WorkLocationName
58    ,SchoolName
59FROM DPISTAFF2009   
60WHERE FirstName = 'George'
61UNION ALL
62SELECT LastName
63    ,FirstName
64    ,BirthYear
65    ,LocalExp
66    ,TotalExp
67    ,TotSalary
68    ,TotFringe
69    ,WorkLocationName
70    ,SchoolName
71FROM DPISTAFF2010   
72WHERE FirstName = 'George'
73UNION ALL
74SELECT LastName
75    ,FirstName
76    ,BirthYear
77    ,LocalExp
78    ,TotalExp
79    ,TotSalary
80    ,TotFringe
81    ,WorkLocationName
82    ,SchoolName
83FROM DPISTAFF2011   
84WHERE FirstName = 'George'
85UNION ALL
86SELECT LastName
87    ,FirstName
88    ,BirthYear
89    ,LocalExp
90    ,TotalExp
91    ,TotSalary
92    ,TotFringe
93    ,WorkLocationName
94    ,SchoolName
95FROM DPISTAFF2012   
96WHERE FirstName = 'George'
97UNION ALL
98SELECT LastName
99    ,FirstName
100    ,BirthYear
101    ,LocalExp
102    ,TotalExp
103    ,TotSalary
104    ,TotFringe
105    ,WorkLocationName
106    ,SchoolName
107FROM DPISTAFF2013   
108WHERE FirstName = 'George'
109UNION ALL
110SELECT LastName
111    ,FirstName
112    ,BirthYear
113    ,LocalExp
114    ,TotalExp
115    ,TotSalary
116    ,TotFringe
117    ,WorkLocationName
118    ,SchoolName
119FROM DPISTAFF2014   
120WHERE FirstName = 'George'
121UNION ALL
122SELECT LastName
123    ,FirstName
124    ,BirthYear
125    ,LocalExp
126    ,TotalExp
127    ,TotSalary
128    ,TotFringe
129    ,WorkLocationName
130    ,SchoolName
131FROM DPISTAFF2015   
132WHERE FirstName = 'George'
133UNION ALL
134SELECT LastName
135    ,FirstName
136    ,BirthYear
137    ,LocalExp
138    ,TotalExp
139    ,TotSalary
140    ,TotFringe
141    ,WorkLocationName
142    ,SchoolName
143FROM DPISTAFF2016   
144WHERE FirstName = 'George'
145	
146select LastName........ from DPISTAFF2008_2009 where name='George'
147union
148select LastName........ from DPISTAFF2009_2010 where name='George'
149	
150Tablename.columnname