Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
PiRatE2785
Starting Member
1 Post |
Posted - 2007-12-13 : 01:10:48
|
Hello everybody I need to a solution to my problem asap.My problem is that i have a sql server 2005 script which is working fine and returning me the correct query. However the same script in access does not return the required query.The Sql server script is as follows:UPDATE TransactionsSET Transactions.EndProductDescription = TB.EndDescriptionFROM Transactions INNER JOIN(SELECT Distinct EndDescription, ProdBatchNo FROM ((SELECT EndProductCode FROM EndProduct WHERE (Product1 IN (SELECT ProductCode FROM Transactions WHERE (ProdBatchNo = '06122007/000002')))) AS TB1 INNER JOIN (SELECT EndProductCode FROM EndProduct WHERE (Product2 IN (SELECT ProductCode FROM Transactions WHERE (ProdBatchNo = '06122007/000002')))) AS TB2 ON TB1.EndProductCode = TB2.EndProductCode) INNER JOIN (SELECT EndProductCode, EndDescription, ProdBatchNo FROM EndProduct, Transactions WHERE (ProdBatchNo = '06122007/000002') AND (Product3 IN (SELECT ProductCode FROM Transactions WHERE (ProdBatchNo = '06122007/000002')))) AS TB3 ON TB2.EndProductCode = TB3.EndProductCode) AS TB ON Transactions.ProdBatchNo = TB.ProdBatchNo WHERE Transactions.EndProductDescription = ''So when i put this query in access same as it is i do not obtain the required results. Can someone please help me urgently on converting the above sql script into access query? |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-13 : 23:38:26
|
Since they use different syntax. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-14 : 03:32:06
|
Post your question at ACCESS forumMadhivananFailing to plan is Planning to fail |
|
|
|
|
|