What will be the equivalent MS-access

Question

User-906034138 posted

What will be the equivalent MS-access query for this query which is written in SQL SERVER?

 

select

                Table1.Field1,

                Table1.Field2,

                Table2.Field1

from Table1

inner join Table2

on Table1.Field1=Table2.Field1

and Table1.Field2=2

 

Please note: must use inner join in access query

Answer 1

User1224940435 posted

You can write same query in access too. 

Answer 2

User-906034138 posted

"You can write same query in access too. "

hello dotnetstep .......

have you tried it....??
but i am getting error.......

Answer 3

User-1148431695 posted

Hi,

Can you please post what error you are getting? As per my understanding the query should work fine in SQL Server. 

Answer 4

User-906034138 posted

Hello riswadkarharshad

I have written this query in SQL server....and i know it is fine in SQl Server

But I want it as MS Access query......................... 

Answer 5

User-906034138 posted

Got the query.....

SELECT Table1.Field1, Table1.Field2, Table2.ID, Table2.Field1
FROM Table1 INNER JOIN Table2 ON Table1.Field1 = Table2.Field1
WHERE (((Table1.Field2)=2));