need help getting a sql query embedde in java to work

From: Adam C. <u_acarbone_at_umassd.edu>
Date: 2000/05/18
Message-ID: <3924468b$1@addressworks2.umassd.edu>#1/1

I'm getting the following exception when trying to run this query on the tables with the following schema I can't figure out why can anyone help. java.sql.SQLException: Invalid column name

query = "SELECT Players.firstname, Players.lastname, Players.jerseynumber, Players.touchdowns, "+

"Players.rushingyards, Players.passingyards,
Players.receivingyards, Players.interceptionsthrown, "+

"Players.interceptionscaught, Players.fumbles,
Players.recoveries, Players.sacks " +

"FROM Players, Playson WHERE Playson.teamname = '"+ teamName +
"'"; AND players.firstname = playson.firstname;";

            try
            {
                  Connection dbConnection = getDatabaseConnection();
                  Statement statement = dbConnection.createStatement();
                  ResultSet result = statement.executeQuery(query);

SELECT Players.firstname, Players.lastname, Players.jerseynumber,

Players.touchdowns, Players.rushingyards, Players.passingyards,
Players.receivingyards, Players.interceptionsthrown,
Players.interceptionscaught, Players.fumbles, Players.recoveries,
Players.sacks FROM Players, Playson WHERE Playson.teamname = 'New England

Patriots'

describe players
Name Null? Type

----------------------------------------- -------- -------------------------

---
FIRSTNAME NOT NULL VARCHAR2(15)
LASTNAME NOT NULL VARCHAR2(20)
JERSEYNUMBER NOT NULL NUMBER(38)
POSITION NOT NULL VARCHAR2(15)
TOUCHDOWNS NUMBER(38)
RUSHINGYARDS NUMBER(38)
PASSINGYARDS NUMBER(38)
RECEIVINGYARDS NUMBER(38)
INTERCEPTIONSTHROWN NUMBER(38)
INTERCEPTIONSCAUGHT NUMBER(38)
FUMBLES NUMBER(38)
RECOVERIES NUMBER(38)
SACKS NUMBER(38)

describe playson
Name Null? Type
----------------------------------------- -------- -------------------------
---
TEAMNAME NOT NULL VARCHAR2(30)
FIRSTNAME NOT NULL VARCHAR2(15)
LASTNAME NOT NULL VARCHAR2(20)
POSITION NOT NULL VARCHAR2(15)

Received on Thu May 18 2000 - 00:00:00 CDT