ot;)
Veln
- Original Message -
From: "Johnny Withers"
To: "Velen Vydelingum"
Cc:
Sent: Sunday, July 24, 2011 17:41
Subject: Re: Query bug
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, "Velen Vydelingum"
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, "Velen Vydelingum" wrote:
Hi,
I have the following query which is fine when I run it from the mysql shell
screen:
select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-0
Hi,
I have the following query which is fine when I run it from the mysql shell
screen:
select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from saletrans_cons
where paymode='Credit') group by supplier_code
but w
matt_lists <[EMAIL PROTECTED]> wrote on 02/02/2005 08:50:16 AM:
> Jay Blanchard wrote:
>
> >[snip]
> >
> >
> >>>No, it isn't ignored...it just returns a FALSE for the IN statement
> >>>
> >>>
> >[/snip]
> >
> >More info
> >
> >"The word IN is an alias for = ANY. Thus these two statements a
Jay Blanchard wrote:
[snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
[/snip]
More info
"The word IN is an alias for = ANY. Thus these two statements are the
same:
SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN(SELE
[snip]
>>
>> No, it isn't ignored...it just returns a FALSE for the IN statement
[/snip]
More info
"The word IN is an alias for = ANY. Thus these two statements are the
same:
SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN(SELECT s1 FROM t2);
Howeve
[snip]
Not only that, shoudlnt it say "column does not exist?" It does not
return an error, it ignores the whole nested query
[/snip]
Not really, because the entire sub query is being viewed as an OR
condition (because of using IN).
--
MySQL General Mailing List
For list archives: http://lists
matt_lists wrote:
Jay Blanchard wrote:
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
False should give no records, it's an "IN ()" sense none match the
condition
instead it gives me every recor
Jay Blanchard wrote:
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
False should give no records, it's an "IN ()" sense none match the condition
instead it gives me every record?!
--
MySQL General
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jay Blanchard wrote:
[snip]
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT CORCOL BLAH FROM tableC WHERE c1
= 'c' AND c2= 'c' );
[/snip]
This query is just badly formed, for instance, where is the table
aliased 'b' in your from statement? Are you showing the complete query?
Here's th
[snip]
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT CORCOL BLAH FROM tableC WHERE c1
= 'c' AND c2= 'c' );
[/snip]
This query is just badly formed, for instance, where is the table
aliased 'b' in your from statement? Are you showing the complete query?
--
MySQL General Mailing List
Fo
matt_lists wrote:
Having a strange bug with nested queries
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT BLAH FROM tableC WHERE c1 =
'c' AND c2= 'c' );
this works, but it should not
there is no "BLAH" column in table C
If I change it to this, it works correctly, as far as I can tell,
Having a strange bug with nested queries
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT BLAH FROM tableC WHERE c1 = 'c'
AND c2= 'c' );
this works, but it should not
there is no "BLAH" column in table C
If I change it to this, it works correctly, as far as I can tell, still
working on v
14 matches
Mail list logo
