Multiple Queries into One Query with seperate fields

[hatstand]

Hi All,

I have tried and failed to find a solution to this. I am trying to create a Query that shows one Field from multiple Queries. I do not want to use Union as this will create one Field, each result must have its own Field. The Fields do not have common information.

Any help would be much appreciated. Thanks

 

[james_lankford]

maybe ...

select 
  table_1.field_1 as [field 1], 
  null as [field 2]
from 
  table_1
  
union all 
  
select 
  null as [field 1], 
  table_2.field_2 as [field 2]
from 
  table_2

 

[hatstand]

Thanks James,

That is so close. My only problem now (if its possible) is to have all returned data at the top of each Field and how to add new Fields. Thanks, very much appreciated.

 

[Joe4]

That is so close. My only problem now (if its possible) is to have all returned data at the top of each Field and how to add new Fields. Thanks, very much appreciated.

What exactly does your data look like?
I suspect that you may have a design flaw in your table structure, which is making things harder than they have to be.

How many tables and fields are we talking about?
Does each table have more than one record?
Can you post some sample data?, and your expected results?

 

[hatstand]

Hi, Due to the nature of the data, I'm afraid I cannot post a sample. But I can tell you what I'm trying to achieve.

I have a Table with multiple fields , one of them being a 'Site Name' and one being a 'Group Name'. (Every 'Site' belongs to a 'Group'). What I need to create is a Query that splits out the 'Group Names' into Fields with each Field being populated with the 'Site Names'. I will then link this Query into Excel where I use each Group in dropdowns etc.

To try to achieve this, I created a Query for each 'Group Name' and populated it with the 'Site Names'. I was then trying to combine them into one Query.

Even as I write this, it seams very amateurish. Which I am. I hope I've explained well enough.

Thanks

 

[james_lankford]

so each Site can belong to only one group ?

but a group can have multiple sites in it ?

so its like Cities and States ?
each City can only belong in one state, but a state can have multiple cities ?

 

[hatstand]

Yes, each site can only belong to one group.

Each group can have multiple sites.

Exactly, Cities and States is a perfect example.

Thanks