SQL 查询问题

Question

select Customer_Info.customername,Customer_Order_Detail_Info.productnum,
       Customer_Order_Detail_Info.costomerorderidfrom Customer_Order_Detail_Info,Customer_Infowhere Customer_Order_Detail_Info.customerid=Customer_Info.customerid
      Customer_Order_Detail_Info.productnum>2000000
总说有问题，请高手指教！

Answer 1

select Customer_Info.customername,Customer_Order_Detail_Info.productnum, 
      Customer_Order_Detail_Info.costomerorderid from Customer_Order_Detail_Info,Customer_Info where Customer_Order_Detail_Info.customerid=Customer_Info.customerid 
      and Customer_Order_Detail_Info.productnum>2000000 

Answer 2

select Customer_Info.customername,Customer_Order_Detail_Info.productnum,
      Customer_Order_Detail_Info.costomerorderidfrom Customer_Order_Detail_Info,Customer_Infowhere Customer_Order_Detail_Info.customerid=Customer_Info.customerid
 AND     Customer_Order_Detail_Info.productnum>2000000

Answer 3

差个and
select Customer_Info.customername,Customer_Order_Detail_Info.productnum,
      Customer_Order_Detail_Info.costomerorderidfrom Customer_Order_Detail_Info,Customer_Infowhere Customer_Order_Detail_Info.customerid=Customer_Info.customerid
 and    Customer_Order_Detail_Info.productnum>2000000

Answer 4

操！不是吧，我是照的书上的实例写的，书上没有and，太盗版了。谢谢！问题还是解决了。

Answer 5

select Customer_Info.customername,Customer_Order_Detail_Info.productnum, 
      Customer_Order_Detail_Info.costomerorderid from Customer_Order_Detail_Info,Customer_Info where Customer_Order_Detail_Info.customerid=Customer_Info.customerid 
      and Customer_Order_Detail_Info.productnum>2000000 
貌似少了一个and