I need a where clause in following situation:

Say I want to query two tables: A and B. In table A there is field 
Afn, while in table B there are 3 fields: Bfn1, Bfn2 and Bfn3. I want  
to do a query, in which the where clause must do these things: 

if A.Afn=1, then check value of B.Bfn1;
if A.Afn=2, then check value of B.Bfn2;
if A.Afn=3, then check value of B.Bfn3.

So how can I create such a where clause to do this? 
Thanks in advance!

Alex Shi

TrafficBuilder Network: 

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to