i have a table,it stores the name and criteria of files, one column contains the compatibility ID of the file...
name | URL | Size| Datetime|compatibility_ID|
now i want a query which retrieves the files according to the compatibility id
means first retrieve all compatible files after all the files which are not compatible....
i want this in one query, how i can make query n how i can combne? plz help...
