上面朋友的方法都尝试了一下,这是我用查询生成器所生成的sql语句,
希望哪位朋友再帮我写一下,如果正确我给120分可以么?
select [Bugs].[Description], [Bugs].[BugID], [Bugs].[timestamp], [Bugs].[Rev], [Bugs].[ExportStatus], [Bugs].[Title], [Bugs].[Status], [Bugs].[AssignedTo], [Bugs].[IssueType], [Bugs].[Severity], [Bugs].[Priority], [Bugs].[Accessibility], [Bugs].[ChangedDate], [Bugs].[ChangedBy], [Bugs].[Environment], [Bugs].[OpenedDate], [Bugs].[OpenedBy], [Bugs].[OpenedRev], [Bugs].[Source], [Bugs].[SourceID], [Bugs].[BetaID], [Bugs].[HowFound], [Bugs].[Lang], [Bugs].[ResolvedDate], [Bugs].[ResolvedBy], [Bugs].[Resolution], [Bugs].[FixedRev], [Bugs].[Cause], [Bugs].[CodeChange], [Bugs].[ClosedDate], [Bugs].[ClosedBy], [Bugs].[KBArticle], [Bugs].[ParentStatus], [Bugs].[DependentLinkStatus], [Bugs].[ParentResolution], [Bugs].[RegressCount], [Bugs].[LinkCount], [Bugs].[MigrationStatus], [Bugs].[PendingDate], [Bugs].[DependentDate], [Bugs].[ParentChangedDate], [Bugs].[ChildLinkCount], [Bugs].[Judge], [Bugs].[ProjectSeverity], [Bugs].[ProjectPriority]
from [Bugs]
where [Bugs].[Resolution]='Postponed'
谢谢了