Cannot join on Memo, OLE, or Hyperlink Object (proje.projeAdi=calisan.proje).

Question

User885003943 posted

Database: MS-Access

This is my database table and column. I give the error. Error Messsage is write the question header.

proje Table

Field Name     Type

id            Integer(Auto Increment)

projeAdi       Long Text

sirketAdi      Long Text

calisan Table

Field Name     Type

id            Integer(Auto Increment)

gun       Date/Time

isTanimi      Long Text

kulID      Integer

basSaat      Date/Time

bitisSaat      Date/Time

proje      Long Text

istipi      Long Text

// Sql Query


sorgu.Connection = baglanti;
        baglanti.Open();
sorgu.CommandText = "SELECT * FROM calisan INNER JOIN proje ON proje.projeAdi = calisan.proje;";
            oku = sorgu.ExecuteReader();