Joining Tables
-
Imagine two table One Table (ForeignCurrency) FC_ID FC_TYPE 1 USD 2 EUR 3 YTL Other table (Rates) FCV_ID FCV_RateIN FCV_RateOUT FCV_DATE 1 1 1 10/13/2005 2 1.345 1.346 10/13/2005 3 1.651 1.654 10/13/2005 I need to join two table in a one query. I do this so Select FC.FC_TYPE,ISNULL(FCV_RateIN,1) FCV_RateIN,ISNULL(FCV_RateOut,1) FCV_RateOut from ForeignCurrency FC LEFT OUTER JOIN Rates R ON FC.FC_ID=R.FCV_ID WHERE FCV_Date='10/13/2005' This give me result as i want. But when i need 10/14/2005 rates it give me empty result set , but i expect FCV_TYPE FCV_RateIn FCV_RateOUT YTL 1 1 USD 1 1 EUR 1 1 How can i re-write code ?
-
Imagine two table One Table (ForeignCurrency) FC_ID FC_TYPE 1 USD 2 EUR 3 YTL Other table (Rates) FCV_ID FCV_RateIN FCV_RateOUT FCV_DATE 1 1 1 10/13/2005 2 1.345 1.346 10/13/2005 3 1.651 1.654 10/13/2005 I need to join two table in a one query. I do this so Select FC.FC_TYPE,ISNULL(FCV_RateIN,1) FCV_RateIN,ISNULL(FCV_RateOut,1) FCV_RateOut from ForeignCurrency FC LEFT OUTER JOIN Rates R ON FC.FC_ID=R.FCV_ID WHERE FCV_Date='10/13/2005' This give me result as i want. But when i need 10/14/2005 rates it give me empty result set , but i expect FCV_TYPE FCV_RateIn FCV_RateOUT YTL 1 1 USD 1 1 EUR 1 1 How can i re-write code ?