Viewing 3 posts - 1 through 4 (of 4 total)
Thank mate, ur the man 🙂 Solved 🙂
June 4, 2011 at 9:26 am
#1334040
LutzM (6/3/2011)
The fact you're expecting other results implies you're looking for a different query then. 😉
Since we don't know your...
June 3, 2011 at 3:52 pm
#1333964
LutzM (6/3/2011)Something likeSELECT MAX(Balance) AS BalanceMax, Customer.FName, Customer.AddressFROM Accounts INNER JOINAccount_mm_Customer ON Accounts.AccountID = Account_mm_Customer.AccountID INNER JOINCustomer ON Account_mm_Customer.CustomerID = Customer.CustomerIDGROUP BY Customer.FName, Customer.Address --, Balance
SELECT MAX(Balance) AS BalanceMax, Customer.FName, Customer.Address
FROM Accounts INNER JOIN
Account_mm_Customer ON Accounts.AccountID = Account_mm_Customer.AccountID INNER JOIN
Customer ON Account_mm_Customer.CustomerID = Customer.CustomerID
GROUP BY Customer.FName, Customer.Address --, Balance
Yep I tried that but...
June 3, 2011 at 12:57 pm
#1333882