6 Replies Latest reply: Oct 5, 2010 3:35 PM by Qlikview-tester RSS

    SQL sentence problems...



      it seems that theres a problem with the following SQL sentence:

      SELECT *

      FROM table1, table2;

      WHERE table1.id = 3 AND table1.name = table2.id


      table1.name and table2.id contains "name". It's just a diferent field name with same info.


      I've tested it in my SQL frontend tool and it works perfectly.


      Any ideas....???


      Thank you in advance!