Hi guys! Lets say you have three tables. CUSTOMER(CUST_ID (PK), NAME) ORDER(CUST_ID (PKFK), SEQ_NR (PK), DATE) ORDERLINE(CUST_ID(PKFK), SEQ_NR (PKFK), ITEM_ID (PKFK)) ITEM_ID references to a item table. Now you want a query to list all orders for a spesific customer, the result: CUST_ID, NAME, SEQ_NR, DATE, TOTAL_NUMBER_OF_ITEMS_IN_ALL_ORDERS, TOTAL_NUMBER_OF_ITEMS_IN_THIS_ORDER Number of rows should equal number of orders for the spesific customer. Result something like this: 1, 'Customer1', 1, '1980-01-01', 10 , 2 1, 'Customer1', 2, '1981-01-01', 10 , 1 1, 'Customer1', 3, '1982-01-01', 10 , 3 1, 'Customer1', 4, '1983-01-01', 10 , 2 1, 'Customer1', 5, '1984-01-01', 10 , 2 Never mind the odd primary keys or why a need that spesific query which doubles up some results. Is this possible in one single query? Thanks in advance for your helpful answers!