请问各位老师， 这个sql语句怎么写啊

IF OBJECT_ID('user_data') IS NOT NULL DROP TABLE user_data
IF OBJECT_ID('department_data') IS NOT NULL DROP TABLE department_data
IF OBJECT_ID('user_online_data') IS NOT NULL DROP TABLE user_online_data
--用户表
CREATE TABLE user_data(
	id INT PRIMARY KEY,
	[name] nVARCHAR(20)  NOT NULL,
	[pwd] VARCHAR(20)  NOT NULL,
	[typeid] INT  NOT NULL	
)
--部门表
CREATE TABLE department_data(
	id INT PRIMARY KEY,
	department NVARCHAR(20) NOT NULL	
)
--用户登录信息表
CREATE TABLE user_online_data(
	id INT IDENTITY(1,1) PRIMARY KEY,
	userId INT NOT NULL,
	loginTime DATETIME	
)

select tab1.*,tab2.department from tab1 , tab2 where tab1.typeid=tab2.id

你是要添加数据还是要查询数据啊