Hiya Folks!
I'm struggling with a complicated subquery issue, and my SQL-fu isn't strong
enough to make a solution apparent. Hopefully one of you experts can give me a
nudge in the right direction :)
The query utilizes data from just one table, which looks like:
idX integer
idY
e.
So if anybody has a link to a doc for subqueries?
From: "mel list_php" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: subquery help for an update
Date: Wed, 16 Feb 2005 14:32:48 +
Hi,
I have one table tableNames ID,name, new_name. The columns ID and name are
popul
Hi,
I have one table tableNames ID,name, new_name. The columns ID and name are
populated. I would like to update the field new_name from an other table
tempName (ID,nameUpdated).
The ID between the 2 tables are the same, but I don't have the info for all
the ID. (so 568 rows in my first table on
order by a.k1, a.total_amt desc
;
Anyone else?
Thanks,
R
-Original Message-
From: Dan Sashko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 9:49 PM
To: Mysql
Subject: Re: Correlated subquery help
isn't the where subquery would always return only one record if set
nal Message -
From: "Rick Robinson" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 6:08 PM
Subject: Correlated subquery help
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently
unsupporte
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a report that lists the the t
On Sat, 5 Jun 2004 21:10:42 -0600
"Daniel Isenhower" <[EMAIL PROTECTED]> wrote:
> > First off, I assume you are using a version of mysql able to
> > handle
> sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
>
> Ugh... I feel dumb :) I'm using 4.0
No worries, there are too many
> First off, I assume you are using a version of mysql able to handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
> FWIW, this is an easy query with a JOIN:
>
> SELECT id FROM work w
> INNER JOIN client_list cl ON cl.id = w.client_id
> WH
On Sat, 5 Jun 2004 19:48:44 -0600
"Daniel Isenhower" <[EMAIL PROTECTED]> wrote:
> This is my first email to the list, so be nice ;-)
Welcome, this is a very helpful list...
> I'm having some difficulty with a subquery that I'm trying to do,
> and was wondering if anyone here can shed some light
This is my first email to the list, so be nice ;-)
I'm having some difficulty with a subquery that I'm trying to do, and was
wondering if anyone here can shed some light on the issue...
This query returns a result as expected:
SELECT id FROM client_list WHERE name="Some Company"
(the id returned
I'm about to pull my hair out on this one so I thought I would see if
somebody could point me in the right direction.
I have a subquery that like like so.
SELECT *
FROM Word
INNER JOIN DomainWord
USING ( word )
INNER JOIN Domain
USING ( domain )
WHERE Domain.domain = ANY(
SELECT Domain.domain
11 matches
Mail list logo