I've 2 fields in a select query rif_CF, ID_CF...
the rif_CF value (C or F) indicate the meaning of the ID_CF...
IF rif_CF=C then the ID_CF is a customer ID, IF rif_CF=F the ID_CF is a furnisher ID.
How can I join 2 tables (customer, and furnisher) in a query?
SELECT ID_doc, data_doc, rif_CF, ID_CF.....!?!?!? thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]