Add a column to a table

[johanhjalmarsso]

Hi!

I have two queries:
Grade CountOfHello1
1 0
2 0
3 1
4 0

Grade CountOfHello2
1 0
2 2
3 1
4 0

I want these two like this:

Grade CountOfHello1 CountOfHello2
1 0 0
2 0 2
3 1 1
4 0 0

How can I do this?

 

[neileg]

Create a new query. Base it on your two existing queries and join the queries on grade. Add the three fields you want to your query grid.