SELECT		MVXADTA_OOHEAD.OAORNO,
		tbCurrentExchangeRate.LastOfCUARAT
INTO		tbExpectedOrderExchangeRate
FROM		OPENQUERY(DB2_Linked server, 'SELECT * FROM MVXADTA_OOHEAD') MVXADTA_OOHEAD
INNER JOIN	tbCurrentExchangeRate ON MVXADTA_OOHEAD.OACUCD = tbCurrentExchangeRate.CUCUCD AND MVXADTA_OOHEAD.OACONO = tbCurrentExchangeRate.CUCONO
WHERE		MVXADTA_OOHEAD.OACONO = 400

SELECT     *
FROM       (
             SELECT Ooops,
                    ThisInformation
             FROM   MyTable
             WHERE  SomeColumn < 4
           ) d
LEFT JOIN  (
             SELECT Yikes,
                    Reason
             FROM   OtherTable
             WHERE  Reference > 9
           ) e ON e.Yikes = d.Ooops

SELECT		w.OAORNO,
		q.CUARAT
INTO		tbl3_SWC_Expected_Order_Exchange_Rate
FROM		OPENQUERY(MOVEX_EXTRANET, 'SELECT * FROM MVXADTASWC.OOHEAD WHERE OACONO = 400') AS w
INNER JOIN	tbl3_SWC_Current_Exchange_Rate AS q ON q.CUCUCD = w.OACUCD AND q.CUCONO = w.OACONO

SELECT		w.OAORNO,
		q.CUARAT
INTO		tbl3_SWC_Expected_Order_Exchange_Rate
FROM		OPENQUERY(MOVEX_EXTRANET, 'SELECT * FROM MVXADTASWC.OOHEAD WHERE OACONO = 400') w
INNER JOIN	tbl3_SWC_Current_Exchange_Rate q ON q.CUCUCD = w.OACUCD AND q.CUCONO = w.OACONO

quote:

---

Originally posted by rwaldron

Thx Guys,
Much Clearer now...

---

SELECT		t1.OECONO,
		t1.OEORNO,
		t1.OECRAM AS Charge,
		t1.OECRAM / t3.LastOfCUARAT ChargeEUR,
		t1.OECRTY,
		CASE WHEN t1.OECRTY = 0 THEN t1.OECRAM / t3.LastOfCUARAT ELSE 0 END ExtCharge,
		CASE WHEN t1.OECRTY = 1 THEN t1.OECRAM / t3.LastOfCUARAT ELSE 0 END IntCharge,
		t1.OECHST
INTO		tbExpectedMarginCharges
FROM		MVXADTASWC_OOCHRG t1
INNER JOIN	MVXADTA_OOHEAD t2 ON t2.OAORNO = t1.OEORNO AND t2.OADIVI = t1.OEDIVI AND t2.OACONO = t1.OECONO
INNER JOIN	tbCurrentExchangeRate t3 ON t3.CUCUCD = t2.OACUCD AND t3.CUCONO = t2.OACONO
WHERE		t1.OECONO = 400
		AND t1.OECHST < '77'

				SELECT		MVXADTA_OOLINE.OBCONO,
								MVXADTA_OOLINE.OBORNO,
								MVXADTA_OOLINE.OBORQT,
								MVXADTA_OOLINE.OBSAPR,
								MVXADTA_OOLINE.OBUCOS,
								tbExpectedOrderExchangeRate.LastOfCUARAT AS ExchangeRate,
								obsapr * (obdlqt + obalqt + obplqt + obrnqt) AS SalesValueForCurr,
								obsapr * (obdlqt + obalqt + obplqt + obrnqt) / tbExpectedOrderExchangeRate.LastOfCUARAT AS SalesValueEUR,
								OBDIA1 * (obrnqt + obalqt + obplqt + obdlqt) AS EngPriceLst,
								OBDIA1 * (obrnqt + obalqt + obplqt + obdlqt) / tbExpectedOrderExchangeRate.LastOfCUARAT AS EngPriceLstEur,
								(OBDIA2 + OBDIA3 + OBDIA4 + OBDIA5 + OBDIA6) * (obrnqt + obplqt + obdlqt + obalqt) AS Discounts,
								(OBDIA2 + OBDIA3 + OBDIA4 + OBDIA5 + OBDIA6) * (obrnqt + obplqt + obdlqt + obalqt) / tbExpectedOrderExchangeRate.LastOfCUARAT AS DiscountsEur,
								MVXADTASWC_OOLICH.O7CRFA AS WARRPERC,
								CASE WHEN MVXADTASWC_OOLICH.O7CRFA Is Null THEN 0 ELSE obsapr * (obdlqt + obalqt + obplqt + obrnqt) / tbExpectedOrderExchangeRate.LastOfCUARAT * O7CRFA END AS WARRANTY,
								obsapr * (obdlqt + obalqt + obplqt + obrnqt) / tbExpectedOrderExchangeRate.LastOfCUARAT - (OBDIA1 * (obrnqt + obalqt + obplqt + obdlqt) / tbExpectedOrderExchangeRate.LastOfCUARAT + (OBDIA2 + OBDIA3 + OBDIA4 + OBDIA5 + OBDIA6) * (obrnqt + obplqt + obdlqt + obalqt) + CASE WHEN MVXADTASWC_OOLICH.O7CRFA Is Null THEN 0 ELSE obsapr * (obdlqt + obalqt + obplqt + obrnqt) / tbExpectedOrderExchangeRate.LastOfCUARAT * O7CRFA END) AS NetSalesStock,
								obucos * (obrnqt + obalqt + obplqt + obdlqt) AS EURCOSTS,
								MVXADTA_OOLINE.OBRGDT,
								MVXADTA_OOLINE.OBORST
				INTO			tbexpectedmarginmaterial
				FROM			MVXADTA_OOLINE
				LEFT JOIN	MVXADTASWC_OOLICH ON MVXADTA_OOLINE.OBPONR = MVXADTASWC_OOLICH.O7PONR AND MVXADTA_OOLINE.OBORNO = MVXADTASWC_OOLICH.O7ORNO AND MVXADTA_OOLINE.OBCONO = MVXADTASWC_OOLICH.O7CONO
				INNER JOIN	tbExpectedOrderExchangeRate ON MVXADTA_OOLINE.OBORNO = tbExpectedOrderExchangeRate.OAORNO
				WHERE			MVXADTASWC_OOLINE.OBCONO = 400
								AND MVXADTA_OOLINE.OBORST < '77'
								AND MVXADTASWC_OOLINE.OBITNO <> 'QUOTEITEM'