Simple Join Statement Help

[ltansey]

I have a problem concerning a join statement query, the two table are called PublicHouse & PublicHouseBeer , below are the following tables are there attributes;

PublicHouse Table

create table "PublicHous e"
(PublicHouseID char (20),
PubName Char (20),
Address varchar (20),
Town char (20),
County varchar (20));

PublicHouse Beer;

create table "Brewer"
(BrewerName char (20),
Address varchar (20),
Town char (20),
County char (20));

The query is list all the publicHouses & related information (address etc) that supply "Ten" Beer. (Ten is the name of the beer).

Below is my attempt at the query;
Select PublicHouse.Pub licHouseID, PublicHouseBeer .BeerName, PublicHouse.Add ress
From "PublicHous e", "PublicHouseBee r"
Where (PublicHouse.Pu blicHouseID = PublicHouseBeer .PublicHouseID)
AND PublicHouseBeer .BeerName = 'Ten';

The following error message came up "PUBLICHOUSEBEE R"."BEERNAME ": invalid identifier

Any help would be very much appreciated

[debasisdas]

where is this table PUBLICHOUSEBEER ?

[susarlasireesha]

Beername is not a field in publichousebeer .check it

[amitpatel66]

You dont have PublicHouseID column as well in the publichousebeer table.
Create the table properly with required fields

[ltansey]

where is this table PUBLICHOUSEBEER ?

Yeah sorry, made a mistake, copy & pasted the wrong table in; the publichousebeer table looks like the following;

Public House Beer Table
create table "PublicHouseBee r"
(PublicHouseID number (20),
BrewerName char (20),
BeerName char (20),
CurrentRating char (20));

Table created.

the beername attribute is there as shown above, I looked at the query so many times, think it may be a structural problem?

I think it may need a second eye to look at

[amitpatel66]

Yeah sorry, made a mistake, copy & pasted the wrong table in; the publichousebeer table looks like the following;

Public House Beer Table
create table "PublicHouseBee r"
(PublicHouseID number (20),
BrewerName char (20),
BeerName char (20),
CurrentRating char (20));

Table created.

the beername attribute is there as shown above, I looked at the query so many times, think it may be a structural problem?

I think it may need a second eye to look at

Your query is in sync with your table structure.
I assume you are running the query from the same schema where you have created a table??