I have a question regarding the SQL query. I have this table shown below
Region | Rep | Item |
---|---|---|
Quebec | Jones | Pencil |
Ontario | Kivell | Binder |
Ontario | Jardine | Pencil |
Ontario | Gill | Pen |
Alberta | Sorvino | Pencil |
Quebec | Jones | Binder |
Ontario | Andrews | Pencil |
Ontario | Jardine | Pencil |
Alberta | Thompson | Pencil |
Quebec | Jones | Binder |
Ontario | Morgan | Pencil |
Quebec | Howard | Binder |
Alberta | Sorvino | Pen |
Alberta | Thompson | Binder |
Ontario | Andrews | Pencil |
Ontario | Jardine | Binder |
Ontario | Jardine | Binder |
Ontario | Andrews | Binder |
I have to filter for each Region then for each Rep and lastly for each Item. So like one example of a table should look like this:
Region | Rep | Item |
---|---|---|
Quebec | Jones | Pencil |
And then I have to go back and choose(filter) the other item and the table should look like this:
Region | Rep | Item |
---|---|---|
Quebec | Jones | Binder |
Quebec | Jones | Binder |
After I copied these two tables I have to go back to Rep and chose the other value and again filter item column again the same to get the tables. After I am done with all Rep and Item I have to go back and choose another Region and repeat the same steps
How can I achieve this with a query?
Advertisement
Answer
If I correctly understood your task, you need few different queries (please, replace table_name
with yours):
SELECT * FROM `table_name` WHERE `Region` LIKE 'Quebec' AND `Rep ` LIKE 'Jones' AND `Item` LIKE 'Pencil'
SELECT * FROM `table_name` WHERE `Region` LIKE 'Quebec' AND `Rep ` LIKE 'Jones' AND `Item` LIKE 'Binder'