Having problems with message search?
In a message dated 9/5/2005 4:14:25 A.M. MDT, baseball-databank@yahoogroups.com writes:
Michael Westbay continued:
> I was actually hoping to have a more technical [illustration],
> such as the Mexican State Problem. Two solutions were proposed:
>
> 1. Add a table joining Mexican cities and states.
> 2. Add a States table joining the Master [birth|death]Country and
> State with full name for the state.
I agree, I've been thinking in terms of examples like this one.
Paul Wendt
This morning I submitted the following to Bill Carle and Pete Palmer:
Bill - when inputting 2005 debuts into my database, it occurred to me that it might be helpful to also include the states (or territories) in similar fashion as what was recently added for Mexico. It's a pretty simple exercise.
Rod Nelson
cc: Pete Palmer
Justin Huber; Melbourne; Victoria (VIC)
Chris Oxspring; Ipswitch; Queensland (QLD)
Glenn Williams; Gosford; New South Wales (NSW)
Grant Balfour; Sydney; New South Wales (NSW)
Shayne Bennett; Adelaide; South Australia (SA)
Travis Blackley; Melbourne; Victoria (VIC)
Cam Cairncross; Cairns; Queensland (QLD)
Trent Durrington; Sydney; New South Wales (NSW)
Mark Ettles; Perth; Western Australia (WA)
Mark Hutton; South Adelaide; South Australia (SA)
Graeme Lloyd; Geelong; Victoria (VIC)
Damian Moss; Darlinghurst; New South Wales (NSW)
Dave Nilsson; Brisbane; Queensland (QLD)
Luke Prokopec; Blackwood; South Australia (SA)*
Joe Quinn; Sydney; New South Wales (NSW)
Craig Shipley; Parramatta; New South Wales (NSW)
John Stephens; Sydney; New South Wales (NSW)
Brad Thomas; Sydney; New South Wales (NSW)
Jeff Williams; Canberra; Australia Capital Territory (ACT)
Shayne Bennett; Adelaide; South Australia (SA)
Travis Blackley; Melbourne; Victoria (VIC)
Cam Cairncross; Cairns; Queensland (QLD)
Trent Durrington; Sydney; New South Wales (NSW)
Mark Ettles; Perth; Western Australia (WA)
Mark Hutton; South Adelaide; South Australia (SA)
Graeme Lloyd; Geelong; Victoria (VIC)
Damian Moss; Darlinghurst; New South Wales (NSW)
Dave Nilsson; Brisbane; Queensland (QLD)
Luke Prokopec; Blackwood; South Australia (SA)*
Joe Quinn; Sydney; New South Wales (NSW)
Craig Shipley; Parramatta; New South Wales (NSW)
John Stephens; Sydney; New South Wales (NSW)
Brad Thomas; Sydney; New South Wales (NSW)
Jeff Williams; Canberra; Australia Capital Territory (ACT)
*there are two cities in Australia named Blackwood; one in Victoria and one in South Australia. I'm assuming that Prokopec was born in South Australia, as the 2005 Reds media guide lists his current residence as Renmark, which is in South Australia.
Also, please note that SABR BioComm show Cairncross POB = Cairns while bbdb lists Queensland.
Also Lloyd DOB = Geelong while bbdb has Victoria.
Rod Nelson
Offline 
Send Email