mysql查询之间的数据_如何从两个日期之间的MySQL查询获取数据？

我正在寻找一种方法来获取两个日期之间的数据，我正在使用下面的查询，

SELECT tbl_docuserstatus.*,tbl_doc.doc_assoc_id,tbl_doctype.doctype_id,tbl_doctype.doctype_name,tbl_doc.doc_reference_number,tbl_doc.doc_date,tbl_doc.doc_start,tbl_doc.creator_id,tbl_doc.control_id,tbl_doc.company_id,tbl_doc.vendor_id,tbl_doc.amount,tbl_doc.currency,tbl_doc.paid,tbl_doc.urgent,tbl_dompany.company_name,tbl_dompany.company_code,tbl_vendor.vendor_name

FROM

tbl_docuserstatus

LEFT JOIN

tbl_doc ON tbl_doc.doc_id = tbl_docuserstatus.doc_id

LEFT JOIN

tbl_doctype ON tbl_doctype.doctype_id = tbl_doc.doctype_id

LEFT JOIN

tbl_company ON tbl_company.company_id = tbl_doc.company_id

LEFT JOIN

tbl_vendor ON tbl_vendor.vendor_id = tbl_doc.vendor_id

LEFT JOIN

tbl_users ON tbl_users.user_id = tbl_doc.creator_id

WHERE

payment_status = '0' AND tbl_doc.company_id='1' AND AND tbl_doc.doctype_id = '1' AND tbl_doc.doc_date BETWEEN '2011-04-05 00:00:00' AND '2011-04-07 00:00:00'这里上面的查询给了我语法错误，所以有人可以告诉我，

如何在两个日期之间从mysql查询中获取数据？