In the last episode (Jun 10), Yariv Omer said:
> I have created the following 2 views:
> CREATE VIEW `cpes_noise_num` AS
[ big view]
>
> CREATE VIEW `my_connect` AS
[ big view joining on cpes_noise_num ]
>
> when I am trying to do something like:
> SELECT count(*) from my_connect
>
> It takes 1
Hi
I have created the following 2 views:
CREATE VIEW `cpes_noise_num` AS
SELECT cpes_dsl_line_stats.id_cpes,
sum(IF(cpes_dsl_line_stats.snr_downstream <
(SELECT snr_downstream FROM admin_configs WHERE admin_id =0),1,0)) AS
snr_downstream, sum(IF((cpes_dsl_line_stats.bit_errors /
cpes_dsl
