hi friends;
please mssql query to access query..
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