"Gregorio" <[EMAIL PROTECTED]> wrote on 25/02/2004 15:19:43:
> This is the query i want to run but i doesn't work.
>
> select id from c_table where users_id in (select id from users where
> locations_id=3) order by data_ora
>
> But it gives me this error:
>
> You have an error in your SQL s
What MySQL version are you running?
Original Message dated 2/25/04, 9:19:43 AM
Author: Gregorio <[EMAIL PROTECTED]>
Re: Nested queries:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order
"Gregorio" <[EMAIL PROTECTED]> wrote:
>
> This is the query i want to run but i doesn't work.
>
> select id from c_table where users_id in (select id from users where
> locations_id=3) order by data_ora
>
> But it gives me this error:
>
> You have an error in your SQL syntax. Check the manual t
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version fo
* Justin French
> I'm trying to dig a bit deeper into mysql queries... I've come across an
> application that i'm building which requires (it would seem on
> the surface)
> many queries, do to the relational nature of the data.
No. SQL was created to do queries on data of a relational nature, thus
Hi,
I'm trying to dig a bit deeper into mysql queries... I've come across an
application that i'm building which requires (it would seem on the surface)
many queries, do to the relational nature of the data.
The actual app is way too complex to explain, but I've come up with a
reasonably simple e
ROTECTED]]
Sent: 16. juni 2002 18:15
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Nested queries and joins
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category != '2'
AND rules.db_login !='$session_login&
002 00:12
To: [EMAIL PROTECTED]
Subject: Nested queries and joins
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
WHERE rules.db_login='$session_login')
AND db_category_int =2
Amit,
Wednesday, January 30, 2002, 7:45:13 AM, you wrote:
ADL> Hi!!
ADL> I am trying to execute the following query. But it is giving
ADL> an error at "select max(columnname)."
ADL> select columname from tablename where columname1 =
ADL> select max(columnname) from tablename
MySQL do
Hi!!
I am trying to execute the following query. But it is giving an error at "select
max(columnname)."
select columname from tablename where columname1 = select max(columnname) from
tablename
Thanks
Amit Lonkar
-
s multi-table deletes that can be used to efficiently
delete rows based on information from one table or even from many tables at
the same time.
-Original Message-
From: Christian Andersson [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2001 19:36
To: Larry Reiter; MySQL Mailing list
S
ROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 7:58 PM
Subject: Nested Queries.
> I have constructed a query which requires a temporary table but I
> would rather use a nested query. In other words, I want to extract a
> set of data and then use that set
I have constructed a query which requires a temporary table but I
would rather use a nested query. In other words, I want to extract a
set of data and then use that set of data as a query against some
other data. Like some sort of SELECT within a SELECT. Can I do this
in MySQL?
Cheers,
LTR
--
way to go
for you nested queries.
On Tue, 7 Aug 2001, Grigory Bakunov
wrote:
> Date: Tue, 7 Aug 2001 09:57:52 +0500
> From: Grigory Bakunov <[EMAIL PROTECTED]>
> To: Steven Robillard <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Nested Queries in MySQl
out how to get MySQL to do nested
queries such as ...
SR> select count(*) from (select count(*) as A, group_col from my_table group by
group_col) as B
SR> Could someone help me out with getting the nested query to work, (I know this can
be done here with a distinct but work with me here
Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a
while now, so I am generally familiar with the structure.
My basic problem right now is trying to figure out how to get MySQL to do nested
queries such as ...
select count(*) from (select count(*) as A
derstand that MySQL does not support subqueries or nested
> queries. Is there a simple workaround or do I have to do a number of
> queries and manipulate them outside of MySQL? I am using PHP for
> server side code. Where can I look for answ
I understand that MySQL does not support subqueries or nested queries. Is there a
simple workaround or do I have to do a number of queries and manipulate them outside
of MySQL? I am using PHP for server side code. Where can I look for answers?
Terence
19 matches
Mail list logo
