Shawn, ----- Original Message ----- From: [EMAIL PROTECTED] To: Dušan Pavlica Cc: Michael Stassen ; list mysql Sent: Wednesday, October 12, 2005 4:45 PM Subject: Re: Help with query
Dušan Pavlica <[EMAIL PROTECTED]> wrote on 10/12/2005 10:00:53 AM: > Thanks, Michal, for your help. > Your query works as I need. > I tried to use same syntax as in MS Access, but results are for some reason > different for this query. I'm working on application which should be able to > connect to MySQL or to MSAccess (users' choice) and I didn't want to write > querries for each DB system separately. Now I see that I will have to. > > Dusan > > ----- Original Message ----- > From: "Michael Stassen" <[EMAIL PROTECTED]> > To: "Dušan Pavlica" <[EMAIL PROTECTED]> > Cc: "list mysql" <mysql@lists.mysql.com> > Sent: Wednesday, October 12, 2005 2:54 PM > Subject: Re: Help with query > > > > Dušan Pavlica wrote: > >> Hello, > >> > >> could someone help me please to construct correct query or tell me what > >> I'm doing wrong? <snip> > >> Kind regards, > >> Dusan Pavlica > > <snip> > > In any case, does this do what you want? > > > > SELECT p.Description, p.ID, pp.Product_ID, pc.Code, pp.StartDate > > FROM products_prices pp > > JOIN products p ON p.ID = pp.Product_ID > > LEFT JOIN products_codes pc ON p.ID = pc.Product_ID AND pc.CodeType = 1 > > WHERE StartDate < Now() > > ORDER BY p.ID, pp.StartDate DESC; > > > > Michael > > > > I don't think you will need to change anything. MS Access should be able to work with Michael's query just fine. Just because the Query Builder in Access (I despise the SQL that comes out of that tool) always nests its JOINs doesn't mean that MS Access can't use un-nested joins. Give it a shot, you may be surprised. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Unfortunately, I'm afraid that MS Access is not able to work with un-nested joins. I tried Michael's solution also with different changes but Access keeps complaining about syntax error and on MSDN help and in one book about Access I have I saw that they use only syntax with nested joins. I don't know if it's matter but I use ADO for accessing MS Access database. Dusan
