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查询中获取数据?