How can I put the results into one column

[rbinder]

Greetings all,

Below is a query were I can get eveything into tow columns but I would like to have the results in one column?

SELECT tbl_Admin_Company_Details.Companyname, tbl_Admin_Company_Details_1.Companyname
FROM tbl_Data_JobOrder INNER JOIN tbl_Admin_Company_Details ON tbl_Data_JobOrder.CompanyID = tbl_Admin_Company_Details.CompanyNumber, tbl_Admin_Company_Details AS tbl_Admin_Company_Details_1 INNER JOIN tbl_Data_Receival ON tbl_Admin_Company_Details_1.CompanyNumber = tbl_Data_Receival.OwnerID
GROUP BY tbl_Admin_Company_Details.Companyname, tbl_Admin_Company_Details_1.Companyname;

The Results are;


tbl_Admin_Company_Details.Companyname tbl_Admin_Company_Details_1.Companyname
Company 1 Company 1
Company 3 Company 2

What I would like is something like
Company 1
Company 3
Company 2

Thanks in advance

rgmb

 

[Kempes]

Could try UNION

 

[neileg]

As Kempes says a union query is what you want. However, a union query often indicates a bad design. Is there any reason for having two tables for this data?