Eclipse Community Forums: Newcomers

Help

Home

Home » Newcomers » Newcomers » SQl to JPQL syntax(SQl to JPQL syntax)

Show: Today's Messages :: Show Polls :: Message Navigator

SQl to JPQL syntax [message #1058261]

Mon, 13 May 2013 12:04

muthu kumar

Messages: 1
Registered: May 2013

Junior Member

I want the following sql query in JQPL syntax: Please help

select P.*,PIN.INSURANCE_COMPANY_ID from PATIENT_INSURANCE PIN right join PATIENT P ON (PIN.Patient_ID = P.ID and PIN.INSURANCE_TYPE = 'P' AND PIN.STATUS = 'A') where P.STATUS = 'A'

Report message to a moderator

Re: SQl to JPQL syntax [message #1058330 is a reply to message #1058261]

Mon, 13 May 2013 14:59

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 5/13/2013 6:59 AM, muthu kumar wrote:
>
>
> I want the following sql query in JQPL syntax: Please help
>
> select P.*,PIN.INSURANCE_COMPANY_ID from PATIENT_INSURANCE PIN right
> join PATIENT P ON (PIN.Patient_ID = P.ID and PIN.INSURANCE_TYPE = 'P'
> AND PIN.STATUS = 'A') where P.STATUS = 'A'

http://www.catb.org/esr/faqs/smart-questions.html#intro

Report message to a moderator

Previous Topic:	Trouble getting my app started on my android device.
Next Topic:	deleting eclipse files before downaloading te latest version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 06:23:10 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter