Hi, I could not do this...
TABLE1 ID NAME price ----- -------- ------ 1 1stname 34 2 2ndname 0 TABLE2 date 1stname 2ndname ------- ------- ------- 20041023 23.5 12.3 As a result I want to get out raws something like this... 1 34 1stname 23.5 2 0 2ndname 12.3 What is the SQL syntax for this puzzle...?? Or is it possible? cheers... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]