0

    Part 1 Combining Tables
    Please respond to BOTH of the following questions:
    Question A
    What is a join command? In addition How can you combine two tables/views together? For instance one table contains 100 rows and the other one contains 200 rows have exactly the same fields and you want to show a query with all data (300 rows).
    Question B
    Why can a group by or order by clause be expensive to process? What is the difference between a where and having clause?
    Part2 Peer Responses
    Please respond to two peers.
    Peer 1 Bill
    The join clause does as it sounds it will join two more tables in a relational database. I looked at some forums for suggestions and one of the better answers I found in how to join the tables would be using the following syntax:
    CREATEVIEW vw_combined AS
    SELECT *
    FROM TABLE1 t1
    JOIN TABLE2 t2 ON t2.col = t1.col
    Again both tables need to have the same columns of data. The having clause is a limit on the results that are produced on the search. The where clause determines what row to be included on the select and what it is specifically looking for.
    Peer 2 Ted’s responce to Bill
    Bill how would you combine the contents of two tables without a JOIN?

                                                                                                                                      Order Now