home *** CD-ROM | disk | FTP | other *** search
/ Club Amiga de Montreal - CAM / CAM_CD_1.iso / files / 526.lha / sqldb_v1.0alpha / test_suites / players_db / select2.out < prev    next >
Text File  |  1991-07-01  |  5KB  |  73 lines
  1. NAME     YEAR_OF_BIRTH  YEAR_JOINED  
  2. -------  -------------  -----------  
  3. Hope     1956           1982         
  4. Everett  1948           1975         
  5. Bishop   1956           1980         
  6. Bailey   1963           1984         
  7. Miller   1934           1972         
  8. NAME   SEX  YEAR_OF_BIRTH  
  9. -----  ---  -------------  
  10. Brown  M    1971           
  11. NAME       YEAR_OF_BIRTH  
  12. ---------  -------------  
  13. Parmenter  1964           
  14. Baker      1963           
  15. Collins    1964           
  16. Wise       1963           
  17. Bailey     1963           
  18. Newcastle  1962           
  19. Parmenter  1963           
  20. Collins    1963           
  21. NAME       TOWN       
  22. ---------  ---------  
  23. Parmenter  Stratford  
  24. Hope       Stratford  
  25. Everett    Stratford  
  26. Wise       Stratford  
  27. Brown      Stratford  
  28. Bishop     Stratford  
  29. Bailey     Plymouth   
  30. Parmenter  Stratford  
  31. NAME    
  32. ------  
  33. Baker   
  34. Brown   
  35. Bishop  
  36. Bailey  
  37. NAME       PLAYERNO  
  38. ---------  --------  
  39. Parmenter  6         
  40. Baker      44        
  41. Collins    27        
  42. Moorman    104       
  43. Newcastle  8         
  44. PLAYERS.PLAYERNO  PLAYERS.NAME  PLAYERS.INITIALS  PLAYERS.YEAR_OF_BIRTH  PLAYERS.SEX  PLAYERS.YEAR_JOINED  PLAYERS.STREET  PLAYERS.HOUSENO  PLAYERS.POSTCODE  PLAYERS.TOWN  PLAYERS.PHONENO  PLAYERS.LEAGUENO  
  45. ----------------  ------------  ----------------  ---------------------  -----------  -------------------  --------------  ---------------  ----------------  ------------  ---------------  ----------------  
  46. 95                Miller        P                 1934                   M            1972                 High Street     33a              5746OP            Douglas       075-867564                         
  47. PLAYERS.PLAYERNO  PLAYERS.NAME  PLAYERS.INITIALS  PLAYERS.YEAR_OF_BIRTH  PLAYERS.SEX  PLAYERS.YEAR_JOINED  PLAYERS.STREET  PLAYERS.HOUSENO  PLAYERS.POSTCODE  PLAYERS.TOWN  PLAYERS.PHONENO  PLAYERS.LEAGUENO  
  48. ----------------  ------------  ----------------  ---------------------  -----------  -------------------  --------------  ---------------  ----------------  ------------  ---------------  ----------------  
  49. 6                 Parmenter     R                 1964                   M            1977                 Haseltine Lane  80               1234KK            Stratford     070-476573       8467              
  50. 44                Baker         E                 1963                   M            1980                 Lewis Street    23               4444LJ            Inglewood     064-368753       1124              
  51. 83                Hope          PK                1956                   M            1982                 Magdalene Road  16a              1812UP            Stratford     070-353548       1608              
  52. 2                 Everett       R                 1948                   M            1975                 Stoney Road     43               3575NH            Stratford     070-237893       2411              
  53. 27                Collins       DD                1964                   F            1983                 Long Drive      804              8457DK            Eltham        079-234857       2513              
  54. 104               Moorman       D                 1970                   F            1984                 Stout Street    65               9437AO            Eltham        079-987571       7060              
  55. 7                 Wise          GWS               1963                   M            1981                 Edgecomb Way    39               9758VB            Stratford     070-347689                         
  56. 57                Brown         M                 1971                   M            1985                 Edgecomb Way    16               4377CB            Stratford     070-473458       6409              
  57. 39                Bishop        D                 1956                   M            1980                 Eaton Square    78               9629CD            Stratford     070-393435                         
  58. 112               Bailey        IP                1963                   F            1984                 Vixen Road      8                6382LK            Plymouth      060-548745       1319              
  59. 8                 Newcastle     B                 1962                   F            1980                 Station Road    4                6584WO            Inglewood     064-458458       2983              
  60. 100               Parmenter     P                 1963                   M            1979                 Haseltine Lane  80               1234KK            Stratford     070-476573       6524              
  61. 28                Collins       C                 1963                   F            1983                 Old Main Road   10               1294QK            Midhurst      072-659599                         
  62. NAME       PLAYERNO  
  63. ---------  --------  
  64. Hope       83        
  65. Everett    2         
  66. Wise       7         
  67. Brown      57        
  68. Bishop     39        
  69. Bailey     112       
  70. Parmenter  100       
  71. Collins    28        
  72. Miller     95        
  73.