close

Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Talk

Why should YOU join our Glock forum?

  • Converse with other Glock Enthusiasts
  • Learn about the latest hunting products
  • Becoming a member is FREE and EASY

If you consider yourself a beginner or an avid shooter, the Glock Talk community is your place to discuss self defense, concealed carry, reloading, target shooting, and all things Glock.

SQL: what is the difference between joining tables and creating views?

Discussion in 'Tech Talk' started by betyourlife, Aug 31, 2008.

  1. betyourlife

    betyourlife on a GLOCK

    5,590
    0
    May 10, 2004
    Seattle, WA
    It seems to me that joining tables through query language is uneccessary if you just create a view using the tables and columns from those tables you want to query. A view is essentially a simplified way of joining the information in tables and running a normal query without all the JOIN, ON, AS hoopla isn't it?

    I have done it both ways and really it seems to me that they are both two different means to the same goal.
     
  2. MadeByMattell

    MadeByMattell

    40
    0
    Nov 6, 2001
    Phoenix, AZ
    I don't do a whole lot of SQL, but when I do, I always create views.
    The reason is, the end users want to write their own reports. Most are very simple queries. However, they aren't technical enough to understand the concept of multiple tables of data and the relationships between them. We map the relationships in a view and have them create their report from the view, not the tables directly. This way they aren't confused by data they don't need to see and they don't make any idiotic choices trying to define relationships themselves.