Hi guys. Is there a way to use a SELECT... IN... syntax in dal? Something like "SELECT * FROM auth_user WHERE id IN (1,3,6) If not, I'll explain my use case, and hope to get your best answer.
I have 2 dbs, one holds auth_user, the other holds some data (projects in this case), with the id of the user that created it. After selecting the all projects, I wanted to show who created them. I cannot use join, because they don't sit on the same database (and they cannot sit on the same database). My 2nd option, is to create an array, of all the users that created project, and match username with it's creator. That's not that bad, but I don't know how to use SELECT IN in dal. The 3rd option, is to query for each user. That makes me want to die, jst so I can roll in my grave. It creates so many unneded queries. On the other hand - that's excatly what I do, as the other options are immpossible, from where I stand. Any ideas? Thanks Yair
