Re: How to do this in Mckoi
"M. A. Sridhar" <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
--- 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. Regards. ===== M. A. Sridhar __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]