MSSQL to Access (SQL Query)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • heavy
    New Member
    • May 2007
    • 1

    MSSQL to Access (SQL Query)

    hi friends;

    please mssql query to access query..

    Code:
    SELECT DISTINCT emlak.id, emlak.state
    FROM emlak INNER JOIN
         ulke ON emlak.ulkeID = ulke.id INNER JOIN
         kategori ON emlak.kategoriID = kategori.id  INNER JOIN
    WHERE (emlak.durumu = '1') AND (ulke.ulke LIKE '%Turkey%') OR
          (emlak.durumu = '1') AND (kategori.category LIKE '%Turkey%') OR
          (emlak.durumu = '1') AND (emlak.baslik LIKE '%Turkey%') OR
          (emlak.durumu = '1') AND (emlak.diger LIKE '%Turkey%')
    ORDER BY emlak.id DESC
Working...