SELECT C_Invoice.ad_org_id,C_Invoice.C_Invoice_ID, C_Invoice.DateInvoiced, C_Invoice.DocumentNo, C_Invoice.IsPaid, C_Invoice.IsSOTrx, C_Invoice.Description, C_Invoice.POReference, ips.C_InvoicePaySchedule_ID, C_Invoice.C_BPartner_ID, C_Invoice.C_Order_ID FROM C_Invoice C_Invoice INNER JOIN C_DocType d ON (C_Invoice.C_DocType_ID=d.C_DocType_ID) LEFT OUTER JOIN C_InvoicePaySchedule ips ON (C_Invoice.C_Invoice_ID=ips.C_Invoice_ID AND ips.IsValid = 'Y') WHERE C_Invoice.AD_Client_ID IN(0,11) AND C_Invoice.AD_Org_ID IN(0,1000000,11,12) AND UPPER(C_Invoice.IsPaid) LIKE "y%"
查詢狀況：
1.單獨使用上面的語句查詢，可以查詢出來2條結果
2.在上面的SQL最后添加語句order by 1 或者單獨添加limit語句時可以查詢出2條結果
3.當你在SQL中加入order by 1 limit 0,3時有3條結果 ，order by 1 limit 0,6時有6條結果，order by 1 limit 0，7時只有2條結果
