Hallo, was ist schneller bzw. belastet die DB weniger stark?
SELECT lngINVInvoiceId, intINVInvoiceNumber, fltINVINvoiceAmount * (1 +((SELECT fltVATVATPercent FROM tblVATCodes WHERE lngVATVATCodeID = tblInvoices.lngVATVATCodeID)/100)) AS fltINVLongPrice, (SELECT nvcCOMCommNumber FROM tblCommissions WHERE tblInvoices.lngCOMCommID = tblCommissions.lngCOMCommID) AS lngCOMCommID FROM tblInvoices WHERE bitINVPayedCpltly = 0 oder SELECT lngINVInvoiceId, intINVInvoiceNumber, fltINVINvoiceAmount * (1 +((SELECT fltVATVATPercent FROM tblVATCodes WHERE lngVATVATCodeID = tblInvoices.lngVATVATCodeID)/100)) AS fltINVLongPrice, nvcCOMCommNumber FROM tblInvoices INNER JOIN tblCommissions ON (tblInvoices.lngCOMCommID = tblCommissions.lngCOMCommID) WHERE bitINVPayedCpltly = 0 Gruss Alex www.aspintranet.de ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
