Re: How to do this in Mckoi
Chas Douglass <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
M. A. Sridhar wrote: > --- Chas Douglass <[email protected]> wrote: > > [Snip] > >>Thanks, it does. >> >>Maybe I should just make a VIEW of the "Patient LEFT JOIN (SELECT ..." >>and then I could pick out the number of meds for a patient quite easily. >> >>Isn't it true that you can only have one LEFT JOIN per query? That >>would be another reason to use the VIEW. >> >>Chas Douglass >> > > You can certainly create a view. But it is not true that you can have only > one left join. In our product, we routinely generate (single) SQL queries > against Mckoi with lots of left joins. Perhaps you are thinking of a similar > limitation that Oracle used to have. > I'm not sure where I read that -- and I don't recall it being mentioned as an Oracle only restriction. But that only speaks to what I recall, not how anything actually works. So thank you for the information and heads up. Some of this is starting to make sense. Chas Douglass --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]