Search the Community
Showing results for tags 'database'.
Found 2 results
-
So often I need to query several table that are linked through some key.I never understood the difference between different types of JOIN although I used it in one of my application, but it just worked without knowing how.The main problem with using the wrong JOIN is that you get lots of duplicated...
-
A view can be created as Create view view_name as <query>Primarily 2 important advantages can be achieved if one provides access through Views and not through actual Tables:-1) Added security- One can always restrict a user from viewing certain things by creating a view that we wish to allow the us...
