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 wherelocations_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 for
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 that
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 by data_ora
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 syntax.
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
* 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
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
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
WHERE rules.db_login
. 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';
?
Peter Normann
-Original
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 doesn't
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
-
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
Subject: Re: 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 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
]
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 of data as a query against some
other data
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
Date |6 Aug 2001 19:59:46 -0700
From |Steven
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
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.) Thanks in advance.
MySQL
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
18 matches
Mail list logo