Re: Select einer Tabelle mitteln einer zweiten Tabelle sortieren

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hallo,

Harry Schmidt wrote:
Jürgen Volke schrieb:

SELECT * FROM medien M inner join
(SELECT * FROM history
WHERE upd = 'N'AND tabelle = 'MEDIEN'
ORDER BY upddate DESC ) X ON
M.mediennr = X.idnr


jetzt bekomme ich noch folgende Fehlermeldung:

Fehler bei der Datenbankanfrage: [MERANT][ODBC SQLBase
driver][SQLBase]00901 PRS CNE Command not properly ended

Ich denke, es liegt am Update ;-)

SELECT * FROM medien M inner join
(SELECT * FROM history
WHERE upd = 'N'AND tabelle = 'MEDIEN'
ORDER BY [upddate] DESC ) X ON
M.mediennr = X.idnr

Gruss - Peter
.

Relevant Pages

  • Re: DLookup and DMax with dates
    ... FROM [History] INNER JOIN (UserEntryData INNER JOIN BOM ON ... History table and the Workorders query. ...
    (microsoft.public.access.queries)
  • Re: SMS_G_System.UserName
    ... The first query won't return the expected results you are looking for sine ... you are essentially returning the same information and just calling it ... The way the data is stored in the History table each ... | inner join SMS_GH_System_COMPUTER_SYSTEM on ...
    (microsoft.public.sms.misc)
  • Returning the most recent entry from a date/timestamp
    ... history for a client rather than just the most recent contact. ... FROM ((((applicant INNER JOIN contract ON applicant.id_contract = ...
    (microsoft.public.access.gettingstarted)
  • Returning the most recent entry from a date/timestamp
    ... history for a client rather than just the most recent contact. ... FROM ((((applicant INNER JOIN contract ON applicant.id_contract = ...
    (microsoft.public.access.gettingstarted)
  • Re: Select einer Tabelle mitteln einer zweiten Tabelle sortieren
    ... Peter Doering schrieb: ... (SELECT * FROM history ... ORDER BY [upddate] DESC) X ON ... LG Harry ...
    (microsoft.public.de.sqlserver)