Re: Sub Queries in MYSQL and JOINS

2004-07-08 Thread Michael Stassen
James Raff wrote: I have MYSQL 3.23.32 on a Cobalt 550 platform. I see from the FAQ's that sub That's a *very* old version. The latest 3.23 is 3.23.58. The current production release is 4.0.20. You should consider upgrading. queries will not work on MYSQL 4.1. Is there a way to use JOIN

Re: sub queries in mysql?

2003-08-14 Thread Roger Baklund
* Jasper Bijl Is there a way to do something like subqueries in one query? Yes, JOIN can be used in many cases where you would think you need sub-queries. A JOIN is also generally faster, according to: URL: http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html I have a customer table (Klant)

RE: sub queries in mysql?

2003-08-14 Thread Jasper Bijl
PROTECTED] Sent: woensdag 13 augustus 2003 13:40 To: [EMAIL PROTECTED] Cc: Jasper Bijl Subject: Re: sub queries in mysql? * Jasper Bijl Is there a way to do something like subqueries in one query? Yes, JOIN can be used in many cases where you would think you need sub-queries. A JOIN