求一个查询语句的写法

Question

我的数据库里有2个表ProjectExpenditures包含（BudgetExpendituresID Money CostItemID）属性和CostItem（CostItemID CostItemName）属性
我想根据ProjectExpenditures表里的BudgetExpendituresID值查询Money 和CostItemName，请问这个SQL查询语句该怎么写？

Answer 1

SELECT [Money],CostItemName FROM ProjectExpenditures P ,CostItem C WHERE P.BudgetExpendituresID =C.CostItemID  AND BudgetExpendituresID=....

Answer 2

SELECT[Money],CostItemName FROM ProjectExpenditures P ,CostItem CWHERE P.CostItemID =C.CostItemID AND BudgetExpendituresID=....

Answer 3

我晕,
SELECT [Money],CostItemName FROM ProjectExpenditures P ,CostItem C WHERE P.CostItemID =C.CostItemID  AND BudgetExpendituresID=....

Answer 4

我这里的BudgetExpendituresID 和CostItemID 是不等的

Answer 5

比如说表ProjectExpenditures里的BudgetExpendituresID值为1，CostItemID的值为2
表CostItem里的CostItemID的值为2 ，CostItemName的值为3； 怎么根据BudgetExpendituresID的1查找到3

Answer 6

最后还是自己搞定了SELECT 
  Money,CostItemName FROM ProjectExpenditures ,CostItem WHERE ProjectExpenditures.BudgetExpendituresID=1 and ProjectExpenditures.CostItemID=CostItem.CostItemID