그전에 통으로 query 문을 작성하다가 최근에 join 으로 쓰려고 하는데 잘안되서 이렇게 질문 드립니다.,

예전 구문

select * from tbl_goodsin, tbl_branch, tbl_mkind, tbl_mainkind, tbl_msubkind, tbl_goods, tbl_buyer
where tbl_goodsin. branch_id = tbl_branch. branch_id
   and tbl_goodsin. mkind_id = tbl_mkind. mkind_id
   and tbl_goodsin. main_id = tbl_mainkind. main_id
   and tbl_goodsin. subkind_id= tbl_msubkind. subkind_id
   and tbl_goodsin. goods_id = tbl_goods. goods_id       
   and tbl_goodsin. buyer_id = tbl_buyer. buyer_id
   and tbl_goodsin. mkind_id =  tbl_goods. mkind_id     
   and tbl_goodsin. main_id =  tbl_goods. main_id
   and tbl_goodsin. subkind_id = tbl_goods. subkind_id
   and tbl_goodsin. branch_id ='999'
   and tbl_goodsin. mkind_id ='W'
   and tbl_goodsin. goods_inday ='20160104'
order by tbl_goodsin. goods_inday asc

                                                                                            테이블명                             공통필드                 테이블명

                                                                                             tbl_goodsin                         mkind_id                     tbl_goods  

                                                                                                                                         main_id

join 문                                                                                                                              subkind_id

select * from tbl_goodsin                                                                                                goods_id
      join  tbl_branch
      on tbl_branch. branch_id = tbl_goodsin. branch_id
      join  tbl_mkind
      on  tbl_mkind. mkind_id = tbl_goodsin. mkind_id
      join tbl_mainkind
      on tbl_mainkind. main_id = tbl_goodsin. main_id
      join  tbl_msubkind
      on tbl_msubkind. subkind_id = tbl_goodsin. subkind_id
      join  tbl_goods
      on tbl_goods. goods_id = tbl_goodsin. goods_id
      join tbl_buyer
      on tbl_buyer. buyer_id = tbl_goodsin. buyer_id
      join tbl_mainkind
      on tbl_mainkind. main_id = tbl_goodsin. main_id
      join tbl_goods
      on tbl_goods. mkind_id = tbl_goodsin. mkind_id
      join tbl_goods
      on tbl_goods. main_id = tbl_goodsin. main_id
      join tbl_goods
      on tbl_goods. subkind_id = tbl_goodsin. subkind_id
where tbl_goodsin. branch_id ='999'
    and tbl_goodsin. mkind_id ='W'
    and tbl_goodsin. goods_inday ='20160104'
order by tbl_goodsin. goods_inday asc

질문 1) join 문에 밑줄친 부분을 작성해서 실행하니 중복되었다고 에러가 발생 합니다

         2) 밑줄친 부분을 삭제하고 실행(goods_id는 제외) 하면 같은 데이터가 중복으로 표시 됩니다

         뭐가 잘못되엇는지요 처음 join 문을 쓰다보니 개념이 잘 안잡혀서요...