sql server - SQL GROUP BY, adding a column from another table works but produces inaccurate information -


so here original query:

select batting.playerid, sum(g) 'g', sum(ab) 'ab', sum(r) 'r', sum(h) 'h', sum(doub) '2b',  sum(trip) '3b',                           sum(hr) 'hr', sum(rbi) 'rbi', sum(sb) 'sb', sum(cs) 'cs', sum(bb) 'bb',                           sum(so) 'so', sum(ibb) 'ibb', sum(hbp) 'hbp', sum(sh) 'sh', sum(sf) 'sf', sum(gidp) 'gidp',                           master.namelast, master.namefirst,      batting         join master on batting.playerid = master.playerid  master.namelast @lastname + '%'  group batting.playerid, master.namelast, master.namefirst

here new query:

select batting.playerid, sum(g) 'g', sum(ab) 'ab', sum(r) 'r', sum(h) 'h', sum(doub) '2b',  sum(trip) '3b',                           sum(hr) 'hr', sum(rbi) 'rbi', sum(sb) 'sb', sum(cs) 'cs', sum(bb) 'bb',                           sum(so) 'so', sum(ibb) 'ibb', sum(hbp) 'hbp', sum(sh) 'sh', sum(sf) 'sf', sum(gidp) 'gidp',                           master.namelast, master.namefirst, fielding.pos     batting         join master on batting.playerid = master.playerid         join fielding on master.playerid = fielding.playerid master.namelast @lastname + '%'  , fielding.pos in ('c', '1b','2b','3b', 'ss', 'lf', 'rf', 'cf', 'of', 'dh') group batting.playerid, master.namelast, master.namefirst, fielding.pos

all doing adding pos column fielding table. had sum columns on batting table totals. results have multiple pos's on fielding table relate sums, ie, has 50 games @ 1 pos, 50 @ pos. query works, numbers being returned getting multiplied few times along way (are lot larger in second query first) , getting multiple records based on pos, want one. thoughts? tried left outer join, didnt anything

the proble 1 record in master table can have multiple records in fielding table, cause query return each record in batting table multiple times. if need data fielding table, need limit single record per playerid.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

qt - Errors in generated MOC files for QT5 from cmake -

i generated moc files qt5 using set (cmake_automoc on) set(cmake_include_current_dir on) then add moc files src using set(src src/main.cpp src/video_widget_surface.cpp src/video_widget.cpp src/video_player.cpp #moc files moc/moc_video_player.cpp moc/moc_video_widget.cpp moc/moc_video_widget_surface.cpp finally add executable using add_executable(somegui ${src}) but errors in moc files saying : /other/workspace/perception/somestuff/moc/moc_video_widget.cpp:54:6: error: 'videowidget' has not been declared /other/workspace/perception/somestuff/moc/moc_video_widget.cpp:62:19: error: 'videowidget' has not been declared /other/workspace/perception/somestuff/moc/moc_video_widget.cpp:68:20: error: 'videowidget' has not been declared /other/workspace/perception/somestuff/moc/moc_video_widget.cpp:68:46: error: non-member function 'const qmetaobject* metaobject()' cannot have cv-qualifier /other/qt5.0.1/5.0.1/gcc_64/include/qtcore/qo...
Read more