"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
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&
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 PR
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
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:
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
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
