>Student | Class
>--
>Steve Lefevre | Math101
>Stacy Adams | Intro to SQL
>Something like
>SELECT Student.Name, Classes.Name FROM Students, Classes WHERE
>Students.StudentID = " . $ID . " AND Classes.Name IN ( SELECT
Classes.Name
>FROM Classes WHERE ClassID = Students.Clas
From: Lefevre, Steven <[EMAIL PROTECTED]>
> ...I think I need a subselect...
It's rare that a sub-select is actually ~needed~, but it does happen. You can almost
always get around it with a JOIN of some sort.
> Final result should look like
> Student | Class
> --
> St
I think the problem is in your table structure. If you did this:
Students:
- Name
- StudentID
Classes:
- ClassID
- Name
StudentsClasses:
- StudentID (PK)
- ClassID (PK)
(You make them a combined key by doing PRIMARY KEY (StudentID,ClassID) in
your table def.)
When you add a student to a class
-Original Message-
From: Lefevre, Steven [mailto:[EMAIL PROTECTED]]
>
> Hey folks-
>
> 'nother question.
> I'm not an SQL expert, and I think I need a subselect, which
> means I need a workaround on MySQL 3.23 or whatever version it is.
>
> Here's the tables I have, with the relevant column
On Tuesday 10 December 2002 07:48, Amittai Aviram wrote:
> Sorry! I meant UPDATE, not INSERT!
>
> UPDATE administrators SET id =
> (SELECT id FROM faculty
> WHERE lastName = "Jones")
> WHERE ordr = 1;
You can use multi-tables updates from 4.0.2
In earlier versions use programming languages.
OOPS! Please note correction below!
> Here is what I would want to do:
>
> INSERT INTO administrators (id) values
> (SELECT id FROM faculty
> WHERE lastName = "Jones")
> WHERE ordr = 1;
Sorry! I meant UPDATE, not INSERT!
UPDATE administrators SET id =
(SELECT id FROM faculty
WHERE lastName =
>
>database,sql,query,table
>Can someone please tell me why this won't work.
>
>if (defined($res)){
> my $stmt = qq{select distinct symbol from portfolio where $res};
> my $sth = $dbh->prepare($stmt);
> $sth->execute();
>
> my $portsymbols = "";
>
> while ($sth->fetchrow) {
> $portsymb
Hi Paul,
There is no direct way to make a string by concatinating strings of
different columns. But your problem can be solved in a different way.
select distinct p.symbol, i.name from portfolio p, portfolio pp, stockinfo i
where pp.type = '401k' AND pp.owner = 'jim'
and p.symbol = i.symbol a
Is this too simple?
select distinct p.symbol, i.name from portfolio p, stockinfo i
where p.symbol = i.symbol
and p.type = '401k'
and p.owner='jim'
order by p.symbol
-
Tom Haapanen -- Software Metrics/Equitrac Corp.
Advanced Printing Solutions -- http://www.metrics.com/
-Original Me
