What's the common column in the 2 query I suppose IDCompany so order by IDCompany Rinaldo
-----Messaggio originale----- Da: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]] Per conto di Luca Ventura Inviato: gioved� 16 maggio 2002 13.49 A: [EMAIL PROTECTED] Oggetto: R: R: R: Retrieve data in Microsoft Access (off-topic) Let's suppose I want to order by "Region" in the first query: is not possible to order by "Region" in the second query because this column is not present in the table "Special_Offers" :-) OK? Regards, Luca -----Messaggio originale----- Da: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]Per conto di Bhushan_Bhangale Inviato: gioved� 16 maggio 2002 13.29 A: [EMAIL PROTECTED] Oggetto: Re: R: R: Retrieve data in Microsoft Access (off-topic) You need to add order by clause in both the queries for the column which is common in both the resultset. ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
