Search results for query: *

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...

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

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...

It's okay GBall

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 =...

Hi Gball, What is TOAD ?

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...

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...