locked
What will be the equivalent MS-access RRS feed

  • 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

    Thursday, October 7, 2010 1:04 PM

Answers

  • 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));
     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 8, 2010 1:31 AM

All replies

  • User1224940435 posted

    You can write same query in access too. 

    Thursday, October 7, 2010 1:33 PM
  • User-906034138 posted

    "You can write same query in access too. "

    hello dotnetstep .......

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

    Thursday, October 7, 2010 11:49 PM
  • 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. 

    Friday, October 8, 2010 12:00 AM
  • 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......................... 

    Friday, October 8, 2010 12:14 AM
  • 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));
     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 8, 2010 1:31 AM