Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by drelefun

  1. drelefun

    removing carriage return after table.

    yep there's a carriage return in the source but i can't get rid of it. its the same one as when you open a new document
  2. drelefun

    removing carriage return after table.

    forgot to add i'm using word 2007
  3. drelefun

    removing carriage return after table.

    hi i've got a table that uses mail merge to populate it. however there is a carriage return that shows up between rows in the table and i can't get rid of it. any suggestions?
  4. drelefun

    Two table join query

    sorry i just meant really for 2 mel 1 4 3 2 mel 2 2 0 2 mel 3 0 2 2 mel 4 3 3 as its based on it being the aflgame_id = 2 and team_id = mel
  5. drelefun

    Two table join query

    i tried your tip ryan but it wasn't what i was after. here is some data from the table aflplayerstats Aflgame_id Team_id Player_id kicks handballs 2 mel 58 12 6 2 mel 358 2 3 2 mel 359 5 14 2 mel 360 8 6 2 mel 362 6 12 2 mel 364 7 7 2 mel 366 4 5 2 mel 370 9 9 2 mel 372 7 14 and aflscore...
  6. drelefun

    Two table join query

    i tried it and it still doesn't work. i'll try some different joins and see how that goes.
  7. drelefun

    Two table join query

    it just seems to get the wrong results and i'm not sure why. separately the results are right SELECT team_id, SUM(goals + behinds) AS 'Scoring Shots' FROM AFLScore GROUP BY team_id and SELECT team_id, SUM(kicks + handballs) AS 'Disposals' FROM AFLPlayerStats GROUP BY team_id but the results...
  8. drelefun

    Two table join query

    Hi I have two tables which i am trying to get data from. The two tables are AFLPlayerStats( aflgame_id(pk), team_id(pk), player_id(pk), kicks, handballs. goals, behinds, hitouts, tackles) and AFLScore(aflgame_id, team_id(pk), quarter(pk), goals, behinds) What I want to do is...
  9. drelefun

    Group by issue

    lol. cheers mate
  10. drelefun

    Group by issue

    wow. i didn't expect it to be so complicated. may i ask why this is required?
  11. drelefun

    Group by issue

    the scores are not recorded cumulatively. its the former. an example of a game is below aflgame_id team_id quarter goals behinds 2 mel 1 4 3 2 mel 2 2 0 2 mel 3 0 2 2 mel 4 3 3 2 stk 1 2 7 2 stk 2 5 0 2 stk 3 4 5 2 stk 4 2 3
  12. drelefun

    Group by issue

    is the reason why we have INNER JOIN AFLScore as awayscore ON awayscore.aflgame_id = AFLGame.aflgame_id AND awayscore.team_id = AFLGame.away and INNER JOIN Team AS away ON away.team_id = AFLGame.away is because the primary key for the AFLScore table is...
  13. drelefun

    Group by issue

    I’m trying to get the total score for a home and away team but not sure how to. Basically the way to get the score is goals x 6 + behinds. This only gets that quarter’s score and I want to group it by the team and game to get total score. I’m also not sure how to differentiate the team in this...
  14. drelefun

    two columns but only need to show one query help

    Well i’ve got the two tables data below. The two tables combined would give the result from my previous post. As you can see there is a home and away column but say i’m making the results page for fremantle i want to see the opposition column from my statement produce Richmond, @Sydney...
  15. drelefun

    two columns but only need to show one query help

    I’m trying to create a sports website to show sports results namely aussie rules football. I want to write a stored procedure to create the results for a separate team results against its opponents for the season. Essentially i have 2 tables Game: game_id, date, home, away Score: game_id...
See more

Part and Inventory Search

Back
Top