C
Casa
I have two tables (this all has to do with drilling). The first table
consists of a drill hole label, from depth, to depth, and geology (i.e. what
rock is present at that interval). My second table has a drill hole label,
sample number, from depth, to depth, and nickel content. I want to be able
to query out what geology is present (from table 1) for each sample (table 2)
interval. The geology intervals do not necessarily match the sample
intervals.
I'm unsure how to code this. Is there anyone out there who could give me
some pointers? Anything I've tried so far has given me bad results.
Casa
consists of a drill hole label, from depth, to depth, and geology (i.e. what
rock is present at that interval). My second table has a drill hole label,
sample number, from depth, to depth, and nickel content. I want to be able
to query out what geology is present (from table 1) for each sample (table 2)
interval. The geology intervals do not necessarily match the sample
intervals.
I'm unsure how to code this. Is there anyone out there who could give me
some pointers? Anything I've tried so far has given me bad results.
Casa