/sci/ - Science & Math

Have a better where clause.

>>2431783
Well, obviously my first try was

AND date BETWEEN "2002-01-01" AND "2003-01-01"

but that just removes 'A - 2001/04/05' , and not the other A.

Subqueries?

select * from table where foo not in (select foo from table where date BETWEEN "2002-01-01" AND "2003-01-01");

>>2431816
Can't say I've heard of foo, but I see what you're doing.

Let me just try it out.

>>2431823
> never heard of foo
check wikipedia

>>2431830
Ah.

Of course.

Hm.

Still seems to be not working as intended. It just removes the 2001 instances, but not the letters (A, in my first post)

Not that very fucking stupid "foo bar" crap in examples again.

And what, are A and B in a separate column from the dates, or are those lines entire strings? And do you just want to exclude all entries with A? Why not just select the ones that are not like "A%" or something?

>>2431862
Works for me.

>>2431956
Figured it out already, thanks.

>>2431935
It's like this. If an entity in the first column is related to any date in 2001, it can't be in the output. Does that make sense?

I fucking hate when people use that "foo-bar" shit in programming. Seriously, I'm raging everytime.

>>2431935
>Not that very fucking stupid "foo bar" crap in examples again.
>>2431976
>I fucking hate when people use that "foo-bar" shit in programming.

ITT: COBOL programmers

Now that we're on the subject anyway, this should show the price of the total sales from the chairs, no?

SELECT SUM( (
price * amount
) )
FROM `sales`
LEFT JOIN `product` ON product.art = sales.art
WHERE product.srtc = 'chair'

>>2431993
nah, just scrubs

>>2431956
That will work right up until there isn't a row containing the date 2001-04-05
Or the foo associated with that date isn't A

So it's entries that aren't both A and 2001? Why not use something like >>2431816 except have the "not in" statement select the A 2001 rows.

Except for the foobar shit. Gahahaha

>>2432052
I don't think you really understood the OP's request.

>>2432055
A is just a name for a variable, could have been anything.

I just didn't want the output to have a name (ie A) in the left column if that was 'connected' to a date in 2001.

>>2432062
Oh, I see now.
My first statement is still true and still points out a flaw in the statement.

So you still select the ones with both A and 2001?

Do they have to be in the same query? Or can you just make two queries - one where you only select the date, and the other one where you select everything?

>>2432089
Well, my final solution was to make a sub-query:

SELECT sales.customer
FROM `sales`
WHERE `date` >= "2003-01-01"

To select the costumers that DID bought stuff in 2003, and in the main query I just added

WHERE customer.customer NOT IN
{subquery here}

And that did the trick.

Gahahaha, good... maybe.

Well, you might not have to do all that if you can modify the program or script that uses that database.

>>2432133
Purely writing queries at the moment to practice.