joining 2 tables

[Sandeep Nemuri]

Hi all ,

I want to join two tables


**

I have table_A:

id1 var1 var2
1   a    b
2   c    d

Table_B:

id2 var3 var4
3   e    f
4   g    h

Expected Output is :

id1 var1 var2 id2 var3 var4
1   a    b     3    e   f
2   c    d     4    g   h


Thanks in advance.
-- 
--Regards
  Sandeep Nemuri