Q&A

  • SQL 좀 봐주세요 ("General SQL error")
select sche_loc, sche_item, sche_stok, sche_flow, sche_time from dbsche ,dimast where sche_item = mast_item(+) order by sche_time and substr(sche_loc, 1, 1) in('1', '2')

"General SQL error"가 나는데 잘 모르겠어요?

이 게시물을
1  COMMENTS
  • Profile
    저렙 • 2001.06.12 20:14
    select sche_loc, sche_item, sche_stok, sche_flow, sche_time from dbsche ,dimast

    where sche_item = mast_item(+)

    and substr(sche_loc, 1, 1) in('1', '2')

    order by sche_time



    오더바이 뒤에 and 구문이 이떠군여.

    ^_^
←First Page
1734 1735 1736 1737 1738 1739 1740 1741 1742 1743
Last Page→
한델 로그인 하기