hi there , i finally worked out union joines are supported in 4.0 i thought it was 4.1 , anyway what are possible examples of its uses ?
say i'm trying to join two tables the second table has 10 rows returned with the key of the first table i would like to only get one record from the first table is this possible in the union statement ? currently i have to loop through the first query statement then in that loop do another select statement within the loop and loop through the second query statement returning those ten rows, if i join them on the same query i'll get multiple records of the first table -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]