Konu: doğru query
selamlar;
hangi yöntem daha doğru ve hızlı fikir verebilirmsiniz.
1. tablelar cross bağlayıp where ile filitrelemekmi?
SELECT Lg_099_10_orfline.LOGICALREF, Lg_099_10_orfline.DATE_,;
Lg_099_10_orfline.AMOUNT, Lg_099_10_orfline.PRICE,;
Lg_099_10_orfline.TOTAL, Lg_099_10_orfline.SHIPPEDAMOUNT,;
Lg_099_10_orfline.LINEEXP, Lg_099_10_orfline.DUEDATE,;
Lg_099_10_orfiche.FICHENO, Lg_099_clcard.CODE, Lg_099_items.CODE,;
Lg_099_items.NAME, Lg_099_10_orfline.SPECODE,;
Lg_099_10_orfiche.DOCTRACKINGNR, Lg_099_10_orfline.CLOSED;
FROM ;
dbo.LG_099_10_ORFLINE Lg_099_10_orfline,;
dbo.LG_099_10_ORFICHE Lg_099_10_orfiche,;
dbo.LG_099_CLCARD Lg_099_clcard,;
dbo.LG_099_ITEMS Lg_099_items;
WHERE ( ( Lg_099_10_orfline.ORDFICHEREF = Lg_099_10_orfiche.LOGICALREF;
AND Lg_099_10_orfline.STOCKREF = Lg_099_items.LOGICALREF );
AND Lg_099_10_orfline.CLIENTREF = Lg_099_clcard.LOGICALREF );
AND ( ( Lg_099_10_orfline.TRCODE = ( 2 );
AND Lg_099_10_orfline.STATUS = ( 4 ) );
AND ( Lg_099_10_orfline.AMOUNT > Lg_099_10_orfline.SHIPPEDAMOUNT;
AND Lg_099_10_orfline.CLOSED = ( 0 ) ) )
yosa
2. join yaparken "ON" ile şartlandırmakmı?
SELECT Lg_099_10_orfline.LOGICALREF, Lg_099_10_orfline.DATE_,;
Lg_099_10_orfline.AMOUNT, Lg_099_10_orfline.PRICE,;
Lg_099_10_orfline.TOTAL, Lg_099_10_orfline.SHIPPEDAMOUNT,;
Lg_099_10_orfline.LINEEXP, Lg_099_10_orfline.DUEDATE,;
Lg_099_10_orfiche.FICHENO, Lg_099_clcard.CODE, Lg_099_items.CODE,;
Lg_099_items.NAME, Lg_099_10_orfline.SPECODE,;
Lg_099_10_orfiche.DOCTRACKINGNR, Lg_099_10_orfline.CLOSED,;
Lg_099_10_defnfldstranv.NUMFLDS1 AS iyil;
FROM ;
DBO.LG_099_10_DEFNFLDSTRANV Lg_099_10_defnfldstranv ;
INNER JOIN DBO.LG_099_10_ORFLINE Lg_099_10_orfline ;
ON Lg_099_10_defnfldstranv.OWNERREF = Lg_099_10_orfline.LOGICALREF ;
INNER JOIN dbo.LG_099_ITEMS Lg_099_items ;
ON Lg_099_10_orfline.STOCKREF = Lg_099_items.LOGICALREF ;
INNER JOIN DBO.LG_099_10_ORFICHE Lg_099_10_orfiche ;
ON Lg_099_10_orfline.ORDFICHEREF = Lg_099_10_orfiche.LOGICALREF ;
INNER JOIN dbo.LG_099_CLCARD Lg_099_clcard ;
ON Lg_099_10_orfiche.CLIENTREF = Lg_099_clcard.LOGICALREF;
ORDER BY Lg_099_10_orfiche.FICHENO
İki kod da farklı.
Bu kodlarla ilgili bir problemim yok.
Sadece doğru kod yöntemini aramktayım!