i want do:

1:
Select code
from eancodes
where eancode = parameter1;

2:
Select price
from articles
where code = ........

i want instead of ..... the code that i have selected from 1.
how do i that?

Select price
from articles
where code IN
(
Select code
from eancodes
where eancode = parameter1
)

thank you!

now it's working

i get only the value from code. but i want values from code, name and city.

what do i wrong:

I am not sure what exactly you want to accomplish, but you have two SELECT statements, from different tables, so you might need a JOIN.

what is the value of a emty field.

i tryed with temp = 0 and temp = NULL and temp < 2.
But he comes never in the if statement. he go's only to the else statement

try IS NULL

how can i select between 2 dates.

i have now

select sum(aantal)
from drank
where datum BETWEEN DATE(NOW(), INTERVAL -7) AND NOW();

WHERE datum BETWEEN CURRENT_DATE - INTERVAL 7 DAY AND CURRENT_DATE

will give you rows up until but not including today


WHERE datum BETWEEN CURRENT_DATE - INTERVAL 7 DAY AND CURRENT_TIMESTAMP

will give you rows up until the current time today