Search results for query: *

Best shown as an example .. table_1 type cust_id order_no seq expire_date print_online 4 1234 a5432 1 01/01/07 null 0 1234 a5432 2 02_04_07 print 0 1234 a5432 3 03/04/07 online 1 1234 a5432 4 03/04/07...

Just like to say thanks for the response and will try your suggestion - I already had one reply to my query as per below and know this works. SELECT MyTable.* FROM MyTable LEFT JOIN (SELECT Oc_Id, Customer_Id FROM MyTable WHERE Expire_Date > GETDATE()) Tbl1 ON...

BRILLIANT!! Many thanks

Thanks - but not the solution - probably my poor attempt to explain the problem. I do not want to select just oc_id = 10 .... there will be thousands of oc_ids but I only want oc_ids (this is a type of journal by the way) and within each group of journals there will be customers (customer_id)...

Example...... initial data set oc_id customer_id order_no expire_date 10 001 0123 01/01/2004 10 001 0124 01/01/2005 10 001 0125 01/01/2006 11 002 4567 01/01/2005 11 002 6789 01/01/2007...

Example...... initial data set oc_id customer_id order_no expire_date 10 001 0123 01/01/2004 10 001 0124 01/01/2005 10 001 0125 01/01/2006 11 002 4567 01/01/2005 11 002 6789 01/01/2007...