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 =
...