On Thu, 16 May 2002, Magnus Wikstr�m wrote: > 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)
This thread is off-topic for this list, please take it offline or to a more appropriate forum. > ----- 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 > Milt Epstein Research Programmer Systems and Technology Services (STS) Campus Information Technologies and Educational Services (CITES) University of Illinois at Urbana-Champaign (UIUC) [EMAIL PROTECTED] ___________________________________________________________________________ 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
