Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mjstar

    OUTER JOINS

    I'm wondering wether I understood outer joins or not. I'm working with Access 97. When I try the following query, I have 39 rows : SELECT ev.* FROM ev. But when I use an left outer join this way, I have many, many rows more: SELECT ev.*, gt.KEY2A FROM ev LEFT JOIN gt ON ev.STATUS1=gt.KEY2A Is...
  2. mjstar

    turning SQL*Plus Code into Access Code

    I tried your tip Terry, but the result is still wrong... I don't know what to do. Maybe I should try to turn it another way. If s.o. can help me ? Merci d'avance Alain TSARAFIDY To think about the person you would like to be is to waste your time. Just be yourself -Anonymous
  3. mjstar

    turning SQL*Plus Code into Access Code

    Hi, Still have a problem with Access. The original code in SQL*Plus is : SELECT machine,nvl (alpha1,'AUTRE') status, LEAST (nextdate,TO_DATE ('24-AUG-2001 06:00:00','DD-MON-YYYY HH24:MI:SS')) PPNextEvt, GREATEST (evtdate,TO_DATE ('30-JUL-2001 06:00:00','DD-MON-YYYY HH24:MI:SS')) PGEvt...
  4. mjstar

    turning SQL*Plus Code into Access Code

    It's okay GBall
  5. mjstar

    turning SQL*Plus Code into Access Code

    Hi guys, I think I found out what the problem was. It's an Access bug (saw it on Microsoft site). The example is: SELECT Employees.LastName, Employees.FirstName, Orders.OrderId From Employees LEFT OUTER JOIN Orders ON ((Employees.EmployeeId = Orders.EmployeeID) and (Orders.ShipCity =...
  6. mjstar

    turning SQL*Plus Code into Access Code

    Hi Gball, What is TOAD ?
  7. mjstar

    turning SQL*Plus Code into Access Code

    Thanks Terry, I've tried your solution, but it didn't work. The thing is that gts_tables and ntc_events are linked tables in Access. They are from an Oracle Database. And I'm just wondering wether Access deletes each Null field. This would be ridiculous. I'm telling you this 'cause I tried to...
  8. mjstar

    turning SQL*Plus Code into Access Code

    I'm looking for a way to turn an SQL*Plus Code into an Access code. The problem is how to nest the outer joins. Here are the original code and the beginning of the new Access one : **************** SQL*Plus Code ******************** SELECT machine,nvl (alpha1,'AUTRE') status, LEAST...

Part and Inventory Search

Back
Top