6 Replies Latest reply: Sep 1, 2011 5:09 PM by Rob Wunderlich RSS

    Auto join??

      Hi,

       

      If I have this 2 tables:

       

      AB
      a1b1
      a2b2
      a3b3
      a4b4
      a5b5
      a6b6

       

      AC
      a1c1
      a2c2

       

      And I want a table that looks like:

       

      AC
      a1c1
      a2c2


      And I don't even do join, I just put everything from table 2 in a table, I end up with

       

      AC
      a1c1
      a2

      c2

      a3-
      a4-
      a5-
      a6-


      What is the best way to get what I want?

      I don't want to change the column name.

       

      I am used to use LEFT JOIN ON etc. in mysql and now it seems like it automatic join if you have the same column names.

       

      Thanks