I've tried what you advised, as well as trying hybridised versions. I either get syntax errors or I get an error telling me that it isn't a retrieval function. I've decided to show my original data in hopes it may simplify things, as I think I've made this more complicated than it has to be.
Some things I've heard in this thread conflict with advise I've already taken in processing my data, so I'll start fresh. I should have done this from my first post, I'm sorry for making this more difficult for the people trying to help me.
I've attached two files:
garchihum: My original data. Key columns were added by myself, in addition to colouration.
garchihum 2: I have removed the keys and whitespace. I've also removed capitals and shortened names to aid in script/command(?) writing.
Every row represents a gene in the gar fish, the reference genome. Each gene is matched to corresponding genes in two other species, chicken and human (in the same row). I have coloured the information relating to each species in three colours. Yellow for Gar, brown for chicken, and green for human.
I have created tables in openoffice base, and I am using sql to write scripts/commands(?) to retrieve only select data from each species.
Right now I am able to select all rows where the confidence of chicken
or human are 1 AND I am able to select all rows where the confidence of chicken
and human are 1.
However, I want to be able to select gar and chicken data if chicken confidence is 1 and exclude the human data when human confidence is 0, or vice versa.
Unfortunately, whether I use a single table or multiple tables, I am in a position where I either get low confidence data from one species if the other species is high confidence OR I am getting data from neither species if one of them have low confidence data.
If anyone wants to be particularly helpful, I can invite them into a dropbox folder with some sample data.