Re: Newbie SQL question

2003-08-14 Thread Andy Jackman
Keith, You're on the right track. But instead of 2 tables, pretend you have three. 1) Home Teams, 2) Schedule 3) Opponent Teams. In reality tables 1 and 3 are the same table, but you mus't get confused between using 'Teams' as Home Teams and Teams as Opponents. In the same way as you named columns

Newbie SQL question

2003-08-11 Thread Warren, Keith
I'm coming from a Filemaker Pro background and have very little SQL experience. I'm trying to write an SQL statement to extract data from two tables. One table has the Team IDs, Team Names for all the high school football teams in the state. The other table has the schedules for all the games. T

RE: newbie: SQL question

2002-11-04 Thread jeff
Try this: http://www.devshed.com/Server_Side/MySQL - Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you hav

RE: newbie: SQL question

2002-11-04 Thread Michael Gargiullo
2002 10:50 AM > To: [EMAIL PROTECTED] > Subject: newbie: SQL question > > > Hi, > > I am just a starter. Anyone can suggest me good web resources for > learning SQL command that I can > use (compatible) with mySQL ? > > I read from www.mysql.com documentation,

newbie: SQL question

2002-11-04 Thread Admin-Stress
Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you have collection for beginner, please :) Thanks, kapot __