You could create a view based on the two tables, and sort it by "Region". This way, you could make fast and efficient queries from the view.
If you wish to view a parent - child relationship in one query you will allways end up with redundant data in the result. (Company info for every special offer) /Magnus ----- Original Message ----- From: "Luca Ventura" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 6:23 PM Subject: R: R: R: Retrieve data in Microsoft Access (off-topic) > Yes...but in this way how can I associate the information about the > companies found > with the first query to the offers found executing the second query? I must > a search for idcompany and I think it is not much performant...what do you > think? > > Regards, > > 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 15.38 > A: [EMAIL PROTECTED] > Oggetto: R: R: R: Retrieve data in Microsoft Access (off-topic) > Priorit�: Alta > > > So order the first query with the parameter you need and the second > still remain 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 15.34 > A: [EMAIL PROTECTED] > Oggetto: R: R: R: Retrieve data in Microsoft Access (off-topic) > > > 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 > > ___________________________________________________________________________ > 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 > > ___________________________________________________________________________ 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
