Conversion of Sql script into QV data model.

[ajaykumar1]

Hi Everyone,

I have the below SQL query which i need to convert into QV script level.

SELECT

A.ID,

B.NAME,

B.QUANTITY,

B.MODELNUMBER,

G.APPLENAME,

B.IMEIDETAILS,

A.QUOTENUMBER,

A.ORDERPRICE,

B.APPLEINVOICEAMOUNT,

A.ORDERCOMPLETESTATUS,

A.ORDERCREATIONDATE,

A.QUOTECREATIONDATE,

B.PAYMENTDATE,

A.CUSTOMERFIRSTNAME,

A.CUSTOMERCITY,

A.REASON,

C.FIRSTNAME AS STAFFFIRSTNAME,

C.LASTNAME AS STAFFLASTNAME,

D.FIRSTNAME AS RETAILERSHOPNAME,

E.NAME AS RETAILERSTATE,

H.NAME AS RETAILERCOUNTRY,

D.ADDRESS AS RETAILERADDRESS,

D.ZIPCODE AS RETAILERZIPCODE

FROM SHOPPINGBASKET A

INNER JOIN

SHOPPINGBASKETITEM B

ON A.ID = B.TID

INNER JOIN

DETAILS C

ON A.SID=C.SID

INNER JOIN

MERCHANT D

ON C.RID=D.RID

INNER JOIN

STATE E

ON D.STATE=E.STATEID

INNER JOIN STATUS F

ON B.ACSTATUS=F.STATUSID

INNER JOIN MODEL G

ON B.NUMBER=G.MODELID

INNER JOIN PLACE H

ON D.COUNTRY=H.COUNTRYID

More Thanks,

Ajay

[vikasmahajan]

It is always better to create QVD and load data from QVD.

Vikas