hi,
i'm working on a project for managing used motorcycles. for security reasons i setup two identical tables. both with the same attributes. ID,UNIID,Manufacurer... one of the tables is named "Com" and the other "Prv". till now i used to search either "Com" or "Prv". but i want to look for a match in both of them and listing the result. i have tried anything i knew, but without luck. please can anyone tell me, how the SQL Statment must look like to get such an output? ------------------------------------- Com ------------------------------------- ID | UNIID | Manufacturer | ------------------------------------- 1 | 12D2 | Yamaha | 2 | 21E3 | test | ------------------------------------- Prv ------------------------------------- ID | UNIID | Manufacturer | ------------------------------------- 1 | 43I2 | Kawasaki | 2 | 68U2 | Something | ------------------------------------- output ???? ------------------------------------- ID | UNIID | Manufacturer | ------------------------------------- 1 | 43I2 | Kawasaki | 2 | 68U2 | Something | 1 | 12D2 | Yamaha | 2 | 21E3 | test | (Data of ID's equals, UNIID's are different, Manufacturer's are different.) many thanx in advance yours christian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php