SQL Error: ORA-00936: missing expression
Posted
by
user2901548
on Programmers
See other posts from Programmers
or by user2901548
Published on 2013-10-21T08:45:36Z
Indexed on
2013/10/21
10:14 UTC
Read the original article
Hit count: 275
sql
Qns: Item Description and the treatment date of all treatments for any patients named Jessie Stange (ie GivenName is Jessie & FamilyName is Stange)
What i wrote: SELECT DISTINCT Description, Date as treatmentDate WHERE doothey.Patient P, doothey.Account A, doothey.AccountLine AL, doothey.Item.I AND P.PatientID = A.PatientID AND A.AccountNo = AL.AccountNo AND AL.ItemNo = I.ItemNo AND (p.FamilyName = 'Stange' AND p.GivenName = 'Jessie');
error:
Error at Command Line:1 Column:30
Error report:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
What is the missing expression???
© Programmers or respective owner