Merge Different Size Queries Possible ? How ?
 

I hope there is a solution to this as its been churning over in that big void in my head for long enough

I have a query that returns a list of results

Say

This results me say 10 sets of results.

projectid, jobid, resultid
1,1,1
1,2,2
1,2,3
2,3,4
2,3,5
2,4,6
3,5,7
3,5,8
3,5,9
3,6,10


What I do with this is then create a explorer tree type javascript menu by comparing the previous values to determine at which level the item should be in the tree.

example

1
---1
------1
---2
------2
------3
2
---3
------4
------5
---4
------6
3
---5
------7
------8
------9
---6
------10

Now the problem with this is that is there is a project or job id present in the database but no results then the query does no return anything but I still wanted it to appear in the tree.

Say project 1 had a job number 3 but there were not any results yet.

How would I achieve this ?

My thought would be is it possible to merge 2 queries so that
you could have an output like


projectid, jobid, resultid
1,1,1
1,2,2
1,2,3
1,3,null
2,3,4
2,3,5
2,4,6
3,5,7
3,5,8
3,5,9
3,6,10

or something like that ?

I hope I've made it clear what my problem but as always any questions are welcome

Thanks

8utt

Anyone, or is this not possible ?

Thanks :)

Try making projects your primary table in the query.

Thanks sussed it.