Hello everyone!
I have an sql statement as follows:
$sql="SELECT reg.regID, reg.memberID, reg.checkNum, membership.lname, membership.fname, finalMembership.lname, finalMembership.fname
FROM reg
LEFT JOIN membership ON reg.memberID= membership.memberID
LEFT JOIN finalMembership ON reg.memberID= finalMembership.memberID
WHERE reg.orgID='$orgID'";
As you can see I have fname & lname from the membership table and fname & lname from the finalMembership table. I want to sort all the records from my sql statement by lname (last name) from both tables.
So if it's possible I want to say
ORDER BY lname";
that doesn't seem to work though So I tried:
ORDER BY finalMembership.lname AND memberhip.lname";
And that doesn't work.
Any ideas????
Any help would be greatly appreciated. Thanks!
