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

    SQL sentence problems...

      Hi,

       

      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!