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 ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to
compose a query, in which the where clause can do this: 

if A.Afn=1, then check Bfn1, 
if A.Afn=2, then check Bfn2,
if A.Afn=3, then check Bfn3.

So how I compose a where clause to do this? Thanks in advance!

Alex Shi

TrafficBuilder Network: 

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

Reply via email to