Hi
I have query1 which shows different channels and those fault duration. Like this:
[channel] [fault duration]
cnn............5
bbc............2
and so on
How I can make a query2 which checks from my channel table are there every channel. And if it not then adds it and set it [fault duration] value to 0? I mean that I have a table where is listed 90 different channels and if my querie doesen't list all of these querie2 adds it and set value what i want.
I have query1 which shows different channels and those fault duration. Like this:
[channel] [fault duration]
cnn............5
bbc............2
and so on
How I can make a query2 which checks from my channel table are there every channel. And if it not then adds it and set it [fault duration] value to 0? I mean that I have a table where is listed 90 different channels and if my querie doesen't list all of these querie2 adds it and set value what i want.
