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
5 1831
where is this table PUBLICHOUSEBEER ?
Beername is not a field in publichousebeer.check it
You dont have PublicHouseID column as well in the publichousebeer table.
Create the table properly with required fields
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 "PublicHouseBeer"
(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
Yeah sorry, made a mistake, copy & pasted the wrong table in; the publichousebeer table looks like the following;
Public House Beer Table
create table "PublicHouseBeer"
(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??
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Barry Young |
last post by:
I am using Access to create a SQL query. It creates an Inner Join Query. I cut and paste the query into PL-SQL. When I try to execute the query I get an error.
ORA 933 SQL command not properly...
|
by: LRW |
last post by:
This has to do with mySQL 101. I know it's supposed to be super
simple, but I'm an idiot. I can't get my join to work (1st time I've
tried doing joins.)
I've read...
|
by: Trent |
last post by:
Hello.
I am trying to execute a statement that works fine in ms sql but will
not work in mysql. There are three tables. user (user_sid,
user_name, user_email), file (file_sid, file_name,...
|
by: Allan |
last post by:
Please help,
below is my problem. Let's say I have 2 tables, a Products table and a
Colors table that go as follow:
Table Products
prodID Name
1 shirt
2 tshirt
|
by: dumbledad |
last post by:
Hi All,
I'm confused by how to replace a SELECT statement in a SQL statement
with a specific value. The table I'm working on is a list of words (a
column called "word") with an index int...
|
by: d.p. |
last post by:
Hi all,
I'm using MS Access 2003.
Bare with me on this description....here's the situation: Imagine insurance,
and working out premiums for different insured properties. The rates for
calculating...
|
by: Fendi Baba |
last post by:
I created a person table with various fields such as Suffix,
Salutation, etc, Some of these fields may not be mandatory for example
suffix. In the actual table itself, I only have a field for...
|
by: MP |
last post by:
Hi
trying to begin to learn database using vb6, ado/adox, mdb format, sql
(not using access...just mdb format via ado)
i need to group the values of multiple fields
- get their possible...
|
by: peaceburn |
last post by:
Hi,
I'm gonna pull my hair in the coming days with these DB2 stored
procedures.
So the issue, let's assume a simple stored procedure like this :
CREATE PROCEDURE MYSCHEMA.PROCEDURE1 ( )...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |