两个有关数据库编程的问题，是高手的请进？！！！！！！！！！！！

[明行]

1、在BCB中sal的日期格式为m/d/y，我已知年与月，要把表中所有的年与月与我已知的年与月相同的记录全列出来，完整的sql语名是怎么的？
2、在二个表中，一个有号码与名称，另一个有号码与金额（号码有重复），怎么将第一个表中的号码找到第二表中的对应的号码，并把号码，名称，金额全都列出来（号码，名称有重复).!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[明行]

你们到什么地方去了.

[rmy]

两个有关数据库编程的问题，是高手的请进？！！！！！！！！！！！

[明行]

请各位发挥......
程序猪
弱水三千
玉笛书生
都在什么地方呢?快来帮忙呀!!!!!!
请各位cfan转达.!!!!!!!!!!!!!!!!!!!!

[KingSunSha]

I don't know what you really want for the 2nd question. pls explain again.

[明行]

没有在机器上试过,回家试试再来,多谢大家!!!!!!!!!!!!!!!!!!!!!!!!

[勉励前行]

第一個問題：(T_SQL)
select * from Table
where year(DateTimeField) = :MyYear and month(DateTimeField) = :MyMonth
第二個問題：(ANSI_SQL)
select a.號碼,a.名稱,b.金額
from Table1 a,Table2 b
where a.號碼 = b.號碼
group by a.號碼,a.名稱,b.金額
order by a.號碼,a.名稱,b.金額

[chenlp99]

T-Sql (Too easy)
1: Select * from YourTable
Where DateDiff(month , YouDateField , YouDate) = 0
2: Select a.Code ,a.Name ,b.Money
From Table1 a , Table2 b
Where b.Code = a.Code

[lingyu2001]

看不懂

[rmy]

多谢大家了，OK了，但是有又了新问题：
select x.num,x.name from table1.dbf x,table2.dbf y
where x.num=y.num and x.num not in
(select num from table2.dbf where extract(year from date)=:valyear and extract
(month from date)=:valmonth group by num)
最后得出：
num name
1 aaa
1 aaa
1 aaa
1 aaa
可是我只要一条记录呀。
请大家指教，多谢了！！！！！！！！！！！！！！！！！

[KingSunSha]

select distinct x.num,x.name from table1.dbf x,table2.dbf y
where x.num=y.num and x.num not in
(select num from table2.dbf where extract(year from date)=:valyear and extract
(month from date)=:valmonth group by num)


or

select x.num,x.name from table1.dbf x,table2.dbf y
where x.num=y.num and x.num not in
(select num from table2.dbf where extract(year from date)=:valyear and extract
(month from date)=:valmonth group by num)
group by x.num, x.name

[明行]

多谢大家！！！！！！！！！！！！！！！！！！！！！！！

[superct]

distinct一下
select distinct x.num,x.name from table1.dbf x,table2.dbf y
where x.num=y.num and x.num not in
(select num from table2.dbf where extract(year from date)=:valyear and extract
(month from date)=:valmonth group by num)

[qianby]

关住

[crycoming]

is it OK?

[amengcat]

实现的时候要考虑效率！
另外，并不是你实现了你想要的结果就证明你的语句没有错误，

[ghibrain]

Q1:在SQL2000中查：FORMAT子句，可格式化日期字符串。
Q2：用master-detail

[jackysoft2001]

先取出你要匹配的字符
再用SQL语句

[yueyue]

up

[TOKA]

1.Select * from mytable where datepart(year,[datecolname])=myyear and datepart(month,[datecolname])=mymonth
2.Select table1.id,table1.name,table1.account from Table1,table2 where Table1.id=table2.id

[zouyannan]

好经典!