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

  • 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();
    Monday, July 14, 2014 6:07 AM

Answers