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.
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 Message-
From: Balteo [mailto:[EMAIL PROTECTED]]
Sent: 17. juni 2002 00:12
To: [EMAIL
. 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
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
Subqueries are not (yet)working in mysql, they will be implemented in the
4.0.x or is it 4.x
which hopefully will be out very soon :-)
so if you are using the 3.23.xxx you have to stick with temporary tables
/Christian
- Original Message -
From: Larry Reiter [EMAIL PROTECTED]
To:
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
Date |6 Aug 2001 19:59:46 -0700
From |Steven Robillard [EMAIL PROTECTED]
Hello!
SR 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.
SR My basic problem right now is trying to figure out how to get