age-
From: Geeta Rajaraman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:00 AM
To: Chris
Subject: Re: MySQL sub-query error.
See..I changed it = only coz the IN wouldn't work. I am guessing its a MySQL
version issue. I am using a version below 4.0.
I am curious about
ubqueries with this query:
SELECT
group_id,
name,
IF(1=userid,'SELECTED',' ')
FROM groups
ORDER BY group_id
Chris
-Original Message-
From: Geeta Rajaraman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 7:0
Good Morning everyone:
I need help figuring out what is wrong with this query. I have tried to
use the LEFT JOIN, but it doesn't solve the purpose.
This is what I am trying to run:
SELECT group_id,name,'SELECTED' FROM groups WHERE group_id = (SELECT
group_id FROM user_groups WHERE use
On Fri, 2002-07-26 at 15:46, Aman Raheja wrote:
> I have the following situation
>
> IDGRP PRC CHECK
> 1 3 10.0Y
> 2 2 12.0Y
> 3 3 32.0N
> 4 1 5.0 N
> 5 1 7.0 Y
> 6 2 9.0 N
> 7 3 17.0N
>
Hello All
I have the following situation
ID GRP PRC CHECK
1 3 10.0Y
2 2 12.0Y
3 3 32.0N
4 1 5.0 N
5 1 7.0 Y
6 2 9.0 N
7 3 17.0N
8 1 11.0N
Problem is th
Hi.
On Fri 2002-07-26 at 09:46:39 -0500, [EMAIL PROTECTED] wrote:
[...]
> Problem is that the sql version I am running does not support sub-queries.
MySQL does not support sub-queries in any version yet.
> Is there another way of getting around the following situation to wirte a
> query so th
