I have big sqlite table that I filtered one column with
IN statement from the GUI. It worked will but I want to filter another second column also based on the first selected. eg full table looks like.
A v A c A n B o B i B k C l C a C z
after first query
A v A c A n C l C a C z
I want to filter this second column only (without the o, i, k available in selection menu).
I found the best solution is the
CREATE TABLE, name it, then use it.
However, I don't know where this table is saved. I can't find it in the explorer however it is there when I
What would you do if you have to do that?