6 Replies Latest reply: Jan 24, 2013 6:32 AM by Gunnar Schie RSS

    How to join two single tables

      Hello

       

      I have just two single tables i like to join. How is the syntax?

       

      SQL SELECT

      actno, nm, supno

      FROM F1100.dbo.Actor;



      SQL SELECT

      R2, R10, VoNo, EntNo, Sup, AcNo, VoDt, AcPr, Qty, AcAm, Txt, Txt2

      FROM F1100.dbo.AcTr;

       

       

      I like to join supno and sup....

       

      Please help