Multiple Sorts on a Join Statement using 3 Tables

[swatisonee]

Hi,

 

I have the foll. $sql which works well.

 

$sqla = "SELECT * FROM Customers c INNER JOIN Custaddress a USING(CID) INNER JOIN Cities t USING(CITYID) WHERE c.Company LIKE '%$customer%' ORDER BY Company asc";

 

But if I wish to do a sort on 3 fields in 3 different tables, i'm getting an error.

 

$sqla = "SELECT * FROM Customers c INNER JOIN Custaddress a USING(CID) INNER JOIN Cities t USING(CITYID) WHERE c.Company LIKE '%$customer%' ORDER BY c. Company asc, t.City asc , a.Zip asc ";

 

Is there a way I can change this please ?

 

 

 

Thanks !

 

 

 

 

[rarebit]

It looks right to me, so try taking out stuff until you find at which point it breaks down, then put back in another way...