Hi, 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: http://www.bestadv.net/index.cfm?ref=7029 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php