Distinctrow issues

[asrg]

Hi .. I'm new to SQL and trying to do the following:
I have 2 tables, tblcustomer and tblorders.
I want the output to show the last order (tblorders.orderdate) date of the individual customers
===================================================
Select DistinctRow
tblcustomer.surname
From
tblcustomer Inner Join
tblorders On tblcustomer.CustID = tblorders.CustID
Order By
tblcustomer.surname
==================================================
I get an output thats just a list of customers that have an order, but doesnt show any details, the last order date..

Help

 

[bborissov]

Are you sure you asked in the right forum?
This is SQL Server forum and SQL Server does not have DistinctRow clause.

BTW if you want to get the record with the bigger date and the order detail try this:

Select * -- put the field list here
From tblorders
Inner Join tblcustomer On tblcustomer.CustID = tblorders.CustID
Inner Join (SELECT CustID, MAX(orderdate) AS orderdate
                   From tblorders
            GROUP BY ) Tbl1 
           ON tblorders.CustID    = Tbl1..CustID AND
              tblorders.orderdate = Tbl1.orderdate
Order By tblcustomer.surname

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[asrg]

Hey thanks buddy ... Im from Access background and trying to up my game.

Works fine .. many thanks