<div>
You could use UNION ALL to do this<br />

<pre><code id="code-8142287">SELECT sqlOut FROM Table1 
UNION ALL
SELECT sqlOut FROM Table2

-- Also you can use UNION which will eliminate any duplicates in the final result

SELECT sqlOut FROM Table1 
UNION
SELECT sqlOut FROM Table2</code></pre>
</div>


You could use UNION ALL to do this


SELECT sqlOut FROM Table1 
UNION ALL
SELECT sqlOut FROM Table2

-- Also you can use UNION which will eliminate any duplicates in the final result

SELECT sqlOut FROM Table1 
UNION
SELECT sqlOut FROM Table2

<div>
malikirfan28:<br />
<br />
Its a pain when you post the same answer isnt it?
</div>


malikirfan28:

Its a pain when you post the same answer isnt it?

<div>
If you need to show data for column 'sqlOut' in both tables, then you help with the UNION ALL statement, but if you want to search from one table to another you should use LEFT JOIN or RIGHT JOIN.
</div>


If you need to show data for column 'sqlOut' in both tables, then you help with the UNION ALL statement, but if you want to search from one table to another you should use LEFT JOIN or RIGHT JOIN.

<div>
<div class="content wysiwyg-content">
Good morning,<br />
Ive done this before, but cant remember how Ive done it.<br />
<br />
Ive for 2 tables with the same field name, but with different values in, Id like to create a query which displays all rows from one table, and in the same coloum the data from the second.<br />
<br />
The coloum name is 'sqlOut' and the tables are imaginativly called 'table1' and 'table2', I thought I could just use join, but I dont have anything to join onto.<br />
<br />
Any suggestions?<br />
<br />
Thank you
</div>
</div>


Good morning,
Ive done this before, but cant remember how Ive done it.

Ive for 2 tables with the same field name, but with different values in, Id like to create a query which displays all rows from one table, and in the same coloum the data from the second.

The coloum name is 'sqlOut' and the tables are imaginativly called 'table1' and 'table2', I thought I could just use join, but I dont have anything to join onto.

Any suggestions?

Thank you

Join table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.