Sub queries

[electroteque]

Hi there, I have Mysql 4.1 on my development machine, I have been 
trying to test out if I am going to be able to do this. What I would 
like to do is return a one to many resultset but without the duplicated 
results in the first query. Hows is this going to be possible ? I would 
like to get all the records out of the second table from a key from the 
first table.

I got this using 4.1.5
mysql> select * from shotlist s limit 1 union select * from sources ss 
where ss.sourceID IN (select sourceID from shotlist s limit 1);
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & 
IN/ALL/ANY/SOME subquery'

I have also notice union joins add one resultset after the other, how 
do you mix this in, or add that resultset as a column in the row 
instead of one after the other ?

Also I am trying to push for 4.1 to be installed on the servers i build 
web apps on. When will be a possible date to say that gamma which is 
practically production quality, to actually say production quality ? 
heheh. Our systems guy will only trust it if it says that, god only 
knows that latest versions are always feature rich and bug fixed darn.

Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]