Hi, I have 6 tables of type (client character, amount numeric) and i want to join them in a single table containing the client and all the amounts (A1, A2, ..., A6) - 6 rows. A client can be in a single table or in many but is distinct in a table. T1 (C, A1) T2 (C, A2) T3 (C, A3) T4 (C, A4) T5 (C, A5) T6 (C, A6) and the result must be T (C, A1, A2, A3, A4, A5, A6) Which is the query? thanks, Catalin
------------------------------------------------------- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
