개발새발 블로그

ORA-00923: FROM keyword not found where expected

String sql = "select c.amount_id, c.m_id, a.p_id, a.amount_size, a.amount_color,"
               + "a.amount_count, p.p_name, p.p_price, p.p_detail, c.a_count " 
               + "from cart c, amount a, product p " 
               + "where c.amount_id = a.amount_id and p.p_id = a.p_id and c.m_id = ? ";

sql이 길어져서 끊어쓰다가 나온 에러

from, where, order 앞에선 한칸 띄워쓰기 해야함!