I have a SQL problem that has been bugging me, it should be simple but I can't 'quite' get the results im after.
I have 2 tables, Table 1 and Table 2.
Table 1 contains lots of orders, each line is an order (order number, customer number etc) , using DISTINCT, I can return just 1 of each order...