Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Forum at

Why should YOU join our forums?

  • Reason #1
  • Reason #2
  • Reason #3

Site Description

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

    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


    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.