Join Statement

[ltansey]

Simple Join Statement Help
--------------------------------------------------------------------------------

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 "PublicHouse"
(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.PublicHouseID, PublicHouseBeer.BeerName, PublicHouse.Address
From "PublicHouse", "PublicHouseBeer"
Where (PublicHouse.PublicHouseID = PublicHouseBeer.PublicHouseID)
AND PublicHouseBeer.BeerName = 'Ten';
 

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

Any help would be very much appreciated

[pbmods]

Heya, ltansey. Welcome to TSDN!

You posted this in both the MySQL and Oracle forums. Which database server are you using?

[code green]

You have named your tables PublicHouse and Brewer,
but your SELECT query refers to them as PublicHouse and PublicHouseBeer.