Why is this SQL code not working?

This is just a very simple code, and if you could help point out why it's not working, it'd be much appreciated.

"
USE Fruit_list
SELECT
a.oranges,
a.pears,
fruitcount = count(*),
apples,
b.banana,
a.dragonfruit
FROM Fruits a
JOIN Fruits b
ON a.banana = b.banana
WHERE dragonfruit between ('20090508') and ('20110508')
AND ActiveFlg = 1
GROUP BY
a.oranges,
a.pears,
apples,
b.banana,
a.dragonfruit
"

Thank you

please define "not working"

it's not much help - what's the error code

But if I had to guess randomly - I'd say your between statement is messed up - you're representing your numbers as strings, remove the parentheses and the quotation marks and try again.