SQL query for combo

[mithani]

Hello everyone,

The following SQL query is for my combo box where I am fetching records from QueryPurchaseParent table. I want to check one more table to see whether I have received invoice or not. If i have received invoice, should not show in my combo box. The second table name is SupplierInvoice and field is supplierInvoice

SELECT QueryPurchaseParent.PurchaseOrderNo FROM QueryPurchaseParent;

Can anyone help me please?

thanks

mithani

 

[mithani]

please see the attached, just showing only one record. It should show all records from purchase minus the records are existing in Invoice table. Any idea?

SQL = SELECT QueryPurchaseParent.PurchaseOrderNo, supplierInvoice.SupplierInvoice FROM QueryPurchaseParent INNER JOIN SupplierInvoice On QueryPurchaseParent.PurchaseOrderNo = SupplierInvoice.PurchaseOrderNo
Where SupplierInvoice.SupplierInvoice = 0

pleassssssssssssssssssssssssssssseeeeeeeee help me.

mithani

 

[mithani]

I am keep trying but no use.

Any help is appreciated.

 

[mithani]

Still waiting for your help. If anything is not clear, please reply me.

mithani

 

[mithani]

hello,

please help me.