34,590
社区成员
发帖
与我相关
我的任务
分享
不懂,帮顶,学习,蹭分.
CREATE TABLE [dbo].[MsgReply](
[id] [int] IDENTITY(1,1) NOT NULL,
[MsgId] [int] NULL,
[Content] [nvarchar](max) NULL,
[ReplyBy] [nvarchar](50) NULL,
[ReplyTime] [datetime] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Department](
[id] [int] IDENTITY(1,1) NOT NULL,
[departname] [nvarchar](50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Message](
[id] [int] IDENTITY(1,1) NOT NULL,
[fromname] [nvarchar](50) NULL,
[toname] [nvarchar](50) NULL,
[title] [nvarchar](100) NULL,
[content] [nvarchar](max) NULL,
[phone] [nvarchar](50) NULL,
[email] [nvarchar](50) NULL,
[address] [nvarchar](255) NULL,
[datetime] [datetime] NULL,
[ip] [nvarchar](50) NULL,
[readyet] [bit] NOT NULL,
[vrpass] [nvarchar](32) NULL,
[vrtime] [datetime] NULL,
[vrclick] [int] NULL
) ON [PRIMARY]
select * from Department as d
INNER JOIN Message as m ON d.id = m.toname
left join msgreply as r on m.id=r.msgid where m.id=2944