conditional view

[gogaak]

hi all,

how do i create view based on a condition.

For example my database consists of a Employee table
*Token ID
Name
AGE
Location
Division.

Now the users of this table would be employees from different divisions.
And i want to create a view for each division for records only belonging to that particular division. And use this view to update records of that division.

Or should i create tables for each division and then give access of each table to the respective division user.

Any response is welcome..

 

[trucktime]

View

Use a a Select Query, in which you can specify the division you want to display the records for.

 

[gogaak]

Use a a Select Query, in which you can specify the division you want to display the records for.

great..
But once i create the views, how do i apply these views to a table of valid users in the database.
I am sorry , I am really new to this...