How to use mysql statement to select and display only

Problem 1: Please post concise and complete code in future posts. Images are not optimal, at least embed them instead of attaching them.
Problem 2: Table 2 is not normalized.

E.g.

SELECT  T1.[Item No.] ,
        CC.[CC_Code] ,
        T1.[SYS Name] ,
        T1.[Day]
FROM    Table1 T1 ,
(   SELECT T2.[CC Code 1] AS [CC_Code]
    FROM   Table2 T2
    WHERE  T1.[CC Code] = T2.[CC Code] ) CC
WHERE   T1.[CC Code]
BETWEEN 80000 AND 90000
UNION ALL
SELECT  T1.[Item No.] ,
        CC.[CC_Code] ,
        T1.[SYS Name] ,
        T1.[Day]
FROM    Table1 T1 ,
(   SELECT T2.[CC Code 2] AS [CC_Code]
    FROM   Table2 T2
    WHERE  T1.[CC Code] = T2.[CC Code] ) CC
WHERE   T1.[CC Code]
BETWEEN 80000 AND 90000;

Select allOpen in new window

btw, don't use special characters and spaces in object names. This requires extensive use of object delimiters.

your code look like this

(select o.sys_name,o.day,o2.cc_code1 from org2 o2 inner join org o on o.cc_code
between 80000 and 90000 and o2.c_code = o.cc_code)
union
(select o.sys_name,o.day,o2.cc_code2 from org2 o2 inner join org o on o.cc_code
between 80000 and 90000 and o2.c_code = o.cc_code)
-- on (o.cc_code > 80000 and o.cc_code < 90000)
union
(select o.sys_name,o.day,o2.cc_code3 from org2 o2 inner join org o on o.cc_code
between 80000 and 90000 and o2.c_code = o.cc_code)
-------------------------------------------------------------------------------------------------------------------------where org was first table,org2 was second table

if  i dont make it hard code can ? i need based on the `count` value to loop through the rc_code 1 , rc_code 2 until the `count` value end

then you need to write procedure...

Simply normalize your data.