I have two columns
| Store | Code |
|---|---|
| Store1.DD | 101 |
| Store2.DE | 103 |
| Store2.DD | 103 |
| Store1.DD | 105 |
| Store2.DD | 107 |
I want to filter all the stores that has the value DD and Codes 101 and 103
I wrote this query
Select * from table
where Store not like ' 
I have two columns
| Store | Code |
|---|---|
| Store1.DD | 101 |
| Store2.DE | 103 |
| Store2.DD | 103 |
| Store1.DD | 105 |
| Store2.DD | 107 |
I want to filter all the stores that has the value DD and Codes 101 and 103
I wrote this query
Select * from table
where Store not like '