Posts

Showing posts from January 30, 2019

USing Join Information to get the information from the table

Image
0 I am new to the SQL. I am learning joins in query so that i eterive the information from the table using information. I am working in this question . Get the EmployeeNumber for the employees and the date they started any given department. Below is my table definition : CREATE TABLE Employees ( EmployeeID int IDENTITY(1,1) PRIMARY KEY ,EmployeeNumber int UNIQUE ,DateOfBirth datetime NOT NULL ,FirstName nvarchar(14) NOT NULL ,MiddleName nvarchar(14) NOT NULL ,LastName nvarchar(16) NOT NULL ,DateHired datetime NOT NULL ) CREATE TABLE Customers ( CustomerID int IDENTITY(1,1) PRIMARY KEY ,FirstName nvarchar(14) NOT NULL ,MiddleName nvarchar(14) NOT NULL ,LastNam