Help getting unique data...

I'm writing a system to load measured electrical data into an Oracle 7 database. Most of the tables are simple and easy to enter and retrieve data from. I now have a situation that requires a bit more Oracle skill than I currently have ;<

A device is tested at several frequencies and eight RF measurements taken per freq. This group of measurements are associated with a bunch of preset test condition (biases).

My problem comes when I attempt to associate this group of test conditions with their tests.

I need to find out whether a GROUP that already exists contains all of the current test conditions (BIAS_SANs).

The tables in question look like:

TABLE rft_freq_meas:

group_san  : NUMBER
freq       : NUMBER
test       : VARCHAR2(10)
value      : NUMBER

TABLE rft_bias_meas:

bias_san   : NUMBER
condition  : VARCHAR2(10)
value      : NUMBER

TABLE rft_bias_group:

group_san : NUMBER
bias_san : NUMBER

I'm using sequence numbers to connect the tables. An example of RFT_BIAS_GROUP might be:

GROUP_SAN BIAS_SAN
--------- ---------

        1          1
        1          2
        1          3
        1          4
        1          5
        5          2
        5          3
        5          4
        5          6
        5          7

I need a way to find the GROUP_SAN that has all the values 1,2,3,4, and 5. This would be GROUP_SAN = 1. It seems like I should be able to use INTERSECT to do this by creating another table with containing only the BIAS_SANs in question, but so far it alludes me.

Help
Thanks
Bob Brothers Received on Wed Dec 02 1998 - 12:22:51 CST