2 Replies Latest reply: Mar 28, 2013 9:26 AM by Ramin Hashimzadeh RSS

    Multiple table queries

    999750
      List the products (Product Code) ordered by customer 11111.?

      this question requires access 3 tables called

      CUSTOMER
      ORDERS
      ORDR_ITEM
      PRODUCT
      PROD_SUPP
      SUPPLIER
        • 1. Re: Multiple table queries
          riedelme
          996747 wrote:
          List the products (Product Code) ordered by customer 11111.?

          this question requires access 3 tables called

          CUSTOMER
          ORDERS
          ORDR_ITEM
          PRODUCT
          PROD_SUPP
          SUPPLIER
          Put the colulmns you want in the SELECT list, the tables you want to join from in the FROM clause, and the join conditions in the WHERE clause something like
          select a.col1, b.col2, c.col3
            from table1 a, table2 b, table3 c
           where a.key = b.key
              and a.key = c.key
          be very careful to specify the join condition correctly
          • 2. Re: Multiple table queries
            Ramin Hashimzadeh
            read about SQL joins

            https://www.google.az/search?q=asp+net+sessionstate+timeout&aq=1&oq=asp.net+-sessionState&aqs=chrome.2.57j0l3j62l2.6708&sourceid=chrome&ie=UTF-8#hl=en&sclient=psy-ab&q=sqljoins&oq=sql+joins&gs_l=serp.3..0l4.1031825.1034152.8.1034715.10.8.0.2.2.0.263.1193.0j5j2.7.0...0.0...1c.1.7.psy-ab.MUtNctqkrc8&pbx=1&bav=on.2,or.r_cp.r_qf.&bvm=bv.44342787,d.bGE&fp=f796daf2265816fb&biw=1600&bih=779

            ---
            Ramin Hashimzadeh