Month: November 2005

Sub queries or nested queries are complete queries wrapped inside of another complete query. Some times this technique is used as a replacement for a JOIN statement. Some times it’s the only way to define exactly what you you want to get from a database. The important thing to learn about sub queries is they…

Consider the following table, orders. buyer         productName  purchaseDate   qtyPurchased     pricePaid ————-  ————— ————— ———– ——— Shannon Lowder pencil         1/1/2000     1         .25 Shannon Lowder paper           1/1/2000     2         1.00 Shannon Lowder Mountain Dew    1/1/2000       1              1.25 Shannon Lowder pencil         1/5/2000     1        …