On 8-8-2014 23:57, Errol Emden wrote:
The SQL script you wrote actually provides the same information as mine
- it lists all movies that Julie Andrews is in but it does NOT provide
who is the leading actor in each movie, as all names selected is that of
Julie Andrews.
must have missed that
I am to list the film title and the leading actor for all of the films 'Julie
Andrews' played in. The following is structure of the tables used:
movie(id, title, yr, director, budget, gross);
actor(id, name);
casting(movieid, actorid, ord). The column name ord has a value of 1 if the
actor
On 8-8-2014 20:35, Errol Emden wrote:
I am to list the film title and the leading actor for all of the films 'Julie
Andrews' played in. The following is structure of the tables used:
movie(id, title, yr, director, budget, gross);
actor(id, name);
casting(movieid, actorid, ord). The column
On 8 Aug 2014, at 7:35pm, Errol Emden eem...@hotmail.com wrote:
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in. The following is structure of the tables used:
movie(id, title, yr, director, budget, gross);
actor(id, name);
On 8 Aug 2014, at 7:59pm, Simon Slavin slav...@bigfraud.org wrote:
SELECT leadActor.name, movie.title FROM casting
JOIN actor AS leadActor ON leadActor.id = casting.actorid
JOIN movie ON movie.id = casting.movieid
JOIN actor AS selectedActor ON selectedActor.id = casting.actorid
WHERE
On Aug 8, 2014, at 8:35 PM, Errol Emden eem...@hotmail.com wrote:
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in.
And another one, for diversity’s sake…
Assuming a slightly different data model:
with
AndrewsMovie
as
(
select
On 8 Aug 2014, at 7:35pm, Errol Emden eem...@hotmail.com wrote:
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in.
You know, one day we should actually solve someone's homework questions. Just
to mess with their head.
Simon.
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in.
The following is structure of the tables used:
movie(id, title, yr, director, budget, gross);
actor(id, name);
casting(movieid, actorid, ord).
The column name ord has a value of 1 if the actor is
On Friday, 8 August, 2014 13:46, Petite Abeille petite.abei...@gmail.com said:
On Aug 8, 2014, at 8:35 PM, Errol Emden eem...@hotmail.com wrote:
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in.
And another one, for diversity's sake...
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What am I doing wrong?
On 8-8-2014 20:35, Errol Emden wrote:
I am to list the film title and the leading actor for all of the films
'Julie Andrews' played in. The following is structure of the tables used:
movie(id, title, yr
Keith...thanks vmuch for your insightful and enlightening approach of
translating 'in parts'. I am truly indebted to you for your mentoring
approach...be well.
Date: Fri, 8 Aug 2014 15:03:13 -0600
From: kmedc...@dessus.com
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What am I doing
.
-Original Message-
From: Errol Emden [mailto:eem...@hotmail.com]
Sent: Friday, 8 August, 2014 16:20
To: General Discussion of SQLite Database; kmedc...@dessus.com
Subject: RE: [sqlite] What am I doing wrong?
Keith...thanks vmuch for your insightful and enlightening approach of
translating
caliber who totally
understands SQL and can provide efficient solutions to problems forum members,
like myself, may have. Again, thanks and be well.
Subject: RE: [sqlite] What am I doing wrong?
Date: Fri, 8 Aug 2014 17:40:28 -0600
From: kmedc...@dessus.com
To: eem...@hotmail.com
CC: sqlite-users
Igor Tandetnik a écrit :
Olivier FAURAX wrote:
I tried with -1 and the length value of the string, but it didn't
help...
Post a small complete compilable program that reproduces the problem. I
don't see anything wrong in the code you've shown - hence, the problem
is likely in the code
Hello,
I'm beginner and uses sqlite3.
I'm trying to record informations in a database, but this fails.
I have followed http://www.sqlite.org/c3ref/stmt.html
rc = sqlite3_open(DB_FILENAME, metadata_db);
rc = sqlite3_exec(metadata_db,
CREATE TABLE IF NOT EXISTS metadata
is autocommit on?
try adding a manual commit.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Olivier FAURAX
Sent: Thursday, March 19, 2009 10:56 AM
To: General Discussion of SQLite Database
Subject: [sqlite] What am I doing
Olivier FAURAX ofau...@neotion.com wrote:
I'm beginner and uses sqlite3.
I'm trying to record informations in a database, but this fails.
I have followed http://www.sqlite.org/c3ref/stmt.html
rc = sqlite3_open(DB_FILENAME, metadata_db);
rc = sqlite3_exec(metadata_db,
CREATE
17 matches
Mail list logo