Ok,
but I would like to be also able to order by an attribute different from
IDCompany...this is the problem.....:-)
thanks,
Luca
-----Messaggio originale-----
Da: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]Per conto di
RBonazzo
Inviato: gioved� 16 maggio 2002 13.58
A: [EMAIL PROTECTED]
Oggetto: R: R: R: Retrieve data in Microsoft Access (off-topic)
Priorit�: Alta
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
___________________________________________________________________________
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
