Dear Sir,
I to create SQL with WHERE 3 conditions or criteria using a MySQL database and a combobox in VB.NEt
Please guide me
So I want 3 criteria, namely all (which means all), Project (which means taking from IDCUSTOMER that starts with the word "Project"), and non-project (which means taking from IDCUSTOMER that does not start with the word "Project")
Sample table
Tabelsales
INVNO IDCUSTOMER
1000 PROJECT001
1001 CUST001
1002 PROJECT045
1003 CUST002
TabledetailI
NVNO PRODUCT QTY
1000 A1 10
1000 A2 25
1001 A2 80
1001 A3 75
1002 A2 80
1002 A10 88
1003 A12 35
Desiredresult
where condition all
NVNO PRODUCT QTY IDCUSTOMER
1000 A1 10 PROJECT001
1000 A2 25 PROJECT001
1001 A2 80 CUST001
1001 A3 75 CUST001
1002 A2 80 PROJECT045
1002 A10 88 PROJECT045
1003 A12 35 CUST002
where condition Project
NVNO PRODUCT QTY IDCUSTOMER
1000 A1 10 PROJECT001
1000 A2 25 PROJECT001
1002 A2 80 PROJECT045
1002 A10 88 PROJECT045
where condition nonProject
NVNO PRODUCT QTY IDCUSTOMER
1001 A2 80 CUST001
1001 A3 75 CUST001
1003 A12 35 CUST002