Loading…
This event has ended. Visit the official site or create your own event on Sched.
TACK ALLA SOM KOM TILL HÖSTKONFERENSEN 2017!

Talarna lägger upp sessionerna själva och vi har påminnt dem om att göra det. 
Saknar ni någon kontakta gärna talarna direkt själva eller maila styrelsen.


Back To Schedule
Tuesday, October 17 • 11:15 - 12:00
Let's Join Together - Joining SQL Table and ViewsRepeat

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Accessing data with SQL becomes more and more important. For resolving a single request data located in multiple tables must be filtered, accumulated and/or merged together. In this way we need to focus our attention on consolidating data split over multiple tables. SQL provides different methods for joining tables and views together, such as inner, outer, exception, cross and full join. A table or view even can be joined with itself or with the result of a different select statement. The result returned from multiple select statements can be merged and even accumulated in a single SQL statement.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Tuesday October 17, 2017 11:15 - 12:00 CEST
Mannagrynskvarnen