LOGO SQL ALT BIRIMLERIYLE ANA BIRIM SETLERI

SET ROWCOUNT 0

SELECT
 (SELECT CODE FROM LG_212_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMALZEMEKOD,
 (SELECT UNITSETF.NAME FROM LG_212_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMZELEMEAD,
LOGICALREF, CODE, NAME, UNITSETREF, LINENR, MAINUNIT, CONVFACT1, CONVFACT2, WIDTH, LENGTH, HEIGHT, AREA, VOLUME_, WEIGHT, WIDTHREF, LENGTHREF, HEIGHTREF, AREAREF, VOLUMEREF, WEIGHTREF, DIVUNIT, MEASURECODE, GLOBALCODE
 FROM
LG_212_UNITSETL UNITSETL   WITH(NOLOCK)



ORDER BY
UNITSETREF, LINENR