473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Oct 22 '07 #1
5 1831
debasisdas
8,127 Expert 4TB
where is this table PUBLICHOUSEBEER ?
Oct 23 '07 #2
Beername is not a field in publichousebeer.check it
Oct 23 '07 #3
amitpatel66
2,367 Expert 2GB
You dont have PublicHouseID column as well in the publichousebeer table.
Create the table properly with required fields
Oct 23 '07 #4
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
Oct 23 '07 #5
amitpatel66
2,367 Expert 2GB
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??
Oct 24 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

7
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...
0
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...
2
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,...
6
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
3
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...
4
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...
2
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...
52
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...
1
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 ( )...
0
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...
0
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...
0
isladogs
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...
0
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...
0
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.