Trying to retrieve two values from two different collections by sql (V 7.2.1)

[deniz]

I am trying to run a query like below to query against two different
collections:

select collection1.id as collection1id, collection2.id as collection2id from
collection1 join collection2 on collection1.name = collection2.name where
collection1.name = 'dummyname';

And as a result, I am only seeing

{
        result-set=
                                {
                                        docs=
                                                [
                                                        {collection2id=1001}, 
                                                        {collection2id=1002}, 
                                                        {collection2id=1003}, 
                                                        {collection2id=1004}, 
                                                        {collection2id=1005}, 
                                                        {collection2id=1001}, 
                                                        {collection2id=1002}, 
                                                        {collection2id=1003}, 
                                                        {collection2id=1004}, 
                                                        {collection2id=1005}, 
                                                        {collection2id=1001}, 
                                                        {collection2id=1002}, 
                                                        {collection2id=1003}, 
                                                        {collection2id=1004}, 
                                                        {collection2id=1005}, 
                                                        {collection2id=1001}, 
                                                        {collection2id=1002}, 
                                                        {collection2id=1003}, 
                                                        {collection2id=1004}, 
                                                        {collection2id=1005}, 
                                                        {collection2id=1001}, 
                                                        {collection2id=1002}, 
                                                        {collection2id=1003}, 
                                                        {collection2id=1004}, 
                                                        {collection2id=1005}, 
                                                        {EOF=true, 
RESPONSE_TIME=2221}
                                                ]
                                }
}

I can understand the reason why the same docs are returned (for each
matching doc on collection1 there are 5 different docs on collection2), but
the thing I dont get is, why collection1id is not anywhere in the result
list while it is in the select statement? 



-----
Zeki ama calismiyor... Calissa yapar...
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html