title: Select two columns for two different tables in SQL Server 2000
body: <p>I have a database with two tables (Table1 and Table2). Table1 has one column ColumnA and Table2 has one column ColumnB i want to select both the columns,</p>
  
  <p>looking for something like:</p>
  
  <p>ColumnA in Table1: </p>
  
  <p>a </p>
  
  <p>b </p>
  
  <p>c </p>
  
  <p>ColumnA in Table2: </p>
  
  <p>d </p>
  
  <p>e </p>
  
  <p>f </p>
  
  <p>Result set should be: </p>
  
  <p>a d</p>
  
  <p>b e</p>
  
  <p>c f</p>
  
  <p>Thanks in advance..</p>