Post your question in a SQL group, this is an Outlook group.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"safs" wrote in message
oups.com...
Create table Employee
Name varchar(10)
Empno where the employee no must be in varchar(XXXNumeric)first three
must be in depart no and other must be in auto number using roll
Age char(2)
Salary currency
Depname default is admin
Manager code varchar(10)

Department
DNo number
Department name
Description

Find which department is having height salary
Find which department manager gets high salary
Summary reports of each department by average age, salary, total exp