I am using the following select statement. It works perfectly in Heidi SQL:
I am getting the error message "Cannot parse the RefreshRow Statemen to generate the refresh row query. It is either invalid or is not protable sql. Can anyone provide help?
Code:
SELECT ord_head_web.DEL_PEROID, ord_head_web.CONFIRM_BY AS CONFIRM_BY_TEL, ord_head_web.MESSAGE, ord_head_web.ORDER_NUMB, ord_head_web.PYMT_TYPE_ AS PYMT_TYPE_TODAY, ord_head_web.UUID, ord_head_web.COUPON_COD, ord_head_web.WEB_PRICE, ord_head_web.DELIV_DATE, ord_head_web.DELIV_DAY, ord_head_web.ID_NUMBER, ord_head_web.INV_NUMBER, rosterne_web.ADDRESS,rosterne_web.INVOICE_NU, rosterne_web.ADDRESS_2,rosterne_web.APARTMENT, rosterne_web.CELLPHONE, rosterne_web.CITY, rosterne_web.COMPANY, rosterne_web.E_MAIL, rosterne_web.`FIRST`, rosterne_web.NEW_FIELD2 as Billing_addr, rosterne_web.HOW_HEAR, rosterne_web.HPHONE, rosterne_web.ID, rosterne_web.`LAST`, rosterne_web.STATE, rosterne_web.SUBS_OK, rosterne_web.WPHONE, rosterne_web.ZIP, rosterne_web.NEW_FIELD4, rosterne_web.CREDITCARD, rosterne_web.CCEXPIRE_M as Ccexpire_Month, rosterne_web.CCEXPIRE_Y as Ccexpire_Year, rosterne_web.NAME_ON_CA as Name_On_Card, rosterne_web.CCEXPIRE as Bill_zip, rosterne_web.DELIV_DAY as Card_type, rosterne_web.UUID as UUIDRN FROM ord_head_web ord_head_web INNER JOIN rosterne_web rosterne_web ON ord_head_web.UUID = rosterne_web.UUID
Comment