Hi, I have several tables linked in various ways so that an inner join is possible. However, at the same time and in the same SQL query, I'd also like to query by some field values in one of the tables.
Two quick questions: a)Will MySQL allow joins that involve more than two tables (in my case, perhaps as many as 5)? b)Can limits on a key field be included in the join in the same SQL statement as does the join, i.e. ... WHERE N>3 AND N<20 ... or something like that. Thanks, Dave. ------- P.S.--It might seem that I'm a lazy bum and unwilling to just try it. My situation is that I'm working on design documentation for the database and working through in my head whether everything can be done in approximately O(N) time. The book I have doesn't mention joins on more than two tables. I will get the database set up and try it soon. Thanks for your patience. ----------------------------------- David T. Ashley ([EMAIL PROTECTED]) Thousand Feet Consulting, LLC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
