Re: join 1 of 2 table depending on a column value

OK, the 2° condition on the ON caluse works now I'll use an IF caluse to select 1 column only, like this: SELECT IF(rif_CF='C',A.descr,F.descr) thanks Ciao, Carlo At 15.43 12/01/2005, you wrote: I have done this numerous times. What you have to do is match 2 conditions in your ON clause. I

Re: join 1 of 2 table depending on a column value

I have done this numerous times. What you have to do is match 2 conditions in your ON clause. I need to make up some information to answer your question because I don't know all of the table names involved in this particular query (you didn't say in your original post). I know you have two tabl

RE: join 1 of 2 table depending on a column value

[snip] How can I join 2 tables (customer, and furnisher) in a query? [/snip] RTFM http://dev.mysql.com/doc/mysql/en/JOIN.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]