Search results for query: *

To all, Thanks for all of your help. It was a join problem. It works great now. Thanks, Jim

Ken, Sorry, the template_id will only match one of the other tables. Thanks, Jim

Ken, I'm sorry this is taking so long, I really appreciate your help. No, the template_id does not always have an enrty in the other 2 tables. Jim

Ken, I'm not sure what you mean. Do you mean is what is in the logfile field the same as what is in the threshold field? If that is what you mean, then no, the data will never be the same. Thanks,

If source_type in opc_source_templ = 8.00 then there should be an entry in opc_monitor_source. If opc_source_templ = 4.00 then there should be an entry in opc_logfile_source. This is an HP OpenView database, so I am not sure that there will ALWAYS be an entry for each. Thanks,

Yes, There is a one to many from opc_source_templ to opc_monitor_cond and a one to many from opc_source_templ to opc_logfile_source. Thanks,

To all, We are running CR 7 and Oracle 8.0.5. There are 3 tables: 1. opc_source_templ 2. opc_monitor_cond 3. opc_logfile_source Table 1 is linked to table 2 by a field called template_id. Table 1 is also linked to table 3 by the same field(template_id). There is a field called source_type_id...