Make table Query

[wdbouk]

Hello,

I have the following querry :

SELECT Prices.*, ISSUE.*
FROM Prices LEFT JOIN ISSUE ON LEFT(Prices.Cusip,8)=LEFT(ISSUE.Cusip9,8);

when i run it , i see the result. However,when i want to modify it to a make table query i receive an error that access can't represent the join expression ON LEFT(Prices.Cusip,8)=LEFT(ISSUE.Cusip9,8)in Design view. Any help? I need the results in a table.
best wishes

 

[PHV]

Have you tried this ?
SELECT Prices.*, ISSUE.* INTO newTableName
FROM Prices LEFT JOIN ISSUE ON LEFT(Prices.Cusip,8)=LEFT(ISSUE.Cusip9,8);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdbouk]

yes. i tried it now but it is unbelievebly slow although i have only 62,000 rows