[DB] SQL문의 활용과 중요성

        Dim strSQL As String = "SELECT " &
                                    "CONCAT('G-', Repeat('0', 6- LENGTH(G_SER)), G_SER) AS SER, " &
                                    " G_GUIDE As GUIDE, COMPANY, G_GUEST As GUEST, " &
                                    "CONCAT(DATE_FORMAT(G_TOFF_DATE, '%b-%d'), ' (', G_WEEK_DAY, ')') AS TOFF_DATE, " &
                                    "G.GC AS GC, G_A_TIME AS ATIME, G_HOLES AS HOLES, G_PAX AS PAX, G_SELL_RATE AS SELL_RATE, " &
                                    "G_SELL_TOTAL AS SUM, G_PAY_METHOD AS BANK, G_PAY_DATE AS PAY_DATE, G_VCHER_DATE AS VCHER_DATE, " &
                                    "CASE " &
                                        "WHEN G_PROG_SER = '3' THEN 'CANCEL' " &
                                        "WHEN G_PROG_SER = '2' THEN 'DONE' " &
                                        "WHEN (`G_PAY_DATE` <> '0000-00-00' AND (`G_PAY_DATE` IS NOT NULL OR LENGTH(`G_PAY_DATE` > 0))) THEN 'PAID' " &
                                        "ELSE '' " &
                                    "END AS STATE, " &
                                    "'' As BALANCE, G_IS_HOLIDAY AS HOLIDAY " &
                               "FROM (GBOOKING B JOIN HGC G On B.GC_SER = G.GC_SER) JOIN HMEMBERS M ON B.G_MEM_SER = M.MEM_SER " & condition_G & ";"