Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [Alex] SQL Order By

Mar 10, 2003, 1:05 PM
dmori
New User (3 posts)
Mar 10, 2003, 1:05 PM
Views: 8615
Shortcut
Quote Reply
Re: [Alex] SQL Order By In reply to
SQL-query : SELECT ADPE.*, equipment.*, location.*FROM ADPE, equipment, locationWHERE ADPE.MEDL_No = equipment.MEDL_Noand ADPE.MEDL_No = location.MEDL_NoORDER BY location.MEDL_No LIMIT 0, 100



MySQL said:
Can't create/write to file '\\sql30d73_0.ism' (Errcode: 2)this is the error message I have been getting... I can only sort by the fields in ADPE... also I would like to sort by different combinations of fields from more than one table....currently, the above is what I have been getting for an error....
Subject Author Views Date
Thread SQL Order By dmori 8842 Mar 10, 2003, 11:08 AM
Post Re: [dmori] SQL Order By 		Paul 8555 Mar 10, 2003, 11:19 AM
Thread Re: [dmori] SQL Order By 		Alex 8630 Mar 10, 2003, 12:51 PM
Thread Re: [Alex] SQL Order By 		dmori 8615 Mar 10, 2003, 1:05 PM
Thread Re: [dmori] SQL Order By 		Alex 8601 Mar 10, 2003, 1:16 PM
Thread Re: [Alex] SQL Order By 		dmori 8605 Mar 10, 2003, 1:45 PM
Thread Re: [dmori] SQL Order By 		Alex 8588 Mar 10, 2003, 1:47 PM
Post Re: [Alex] SQL Order By 		dmori 8524 Mar 10, 2003, 2:01 PM