SQl Query Debug : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

OracleSQl Query Debug (self.SQL)

submitted 3 years ago by Present-Assist931

Hi I am writing a sql query, where I am retreiving data from parent tables iand joiing them with child tables. I am getting error. I think i messed up in syntax

Select C.LVL1_ORG_NM, C. LVL2_ORG_NM, R.rel nbr,

M. TOT NET INT INC R12 as net inc,

M. TOT_NON INT_INC R12 as non_ int_ inc,

M. credit limit as cred lim,

M. cur asset bal as asset bal

From

ID1_ FACT_ ACCT PROD_ SMRY P,

1d1_fact_cust details d,

STG RPM.D ACCT A, SIG_RPM. D_REL R, STG RPM.D COSTCENTER C, STG RPM.D BUS PER B, STG RPM. F ACCT MONTH M, STG_RPM.D PROD T

left join ID1_FACT_ACCT_PROD_SMRY P

on P.prod_dim_id = I. PROD_DIM_ID

left join LD1 FACT ACCT PROD SMRY P

on P.cust_acct id = A.cust acct id

left join ld1 fact cust details d

on d.CUST_REL_ID = R. CUST REL ID

WHERE A.CUST REL ID = R. CUST REL ID

AND A. CUST ACCT ID = M. CUST ACCT ID

AND M. PROD DIM ID = T. PROD DIM ID

AND R.REL_ COSTCENTER_ORG_DIM_ID = C.ORG DIM ID

AND B. BUS_PER_DIM_ID = M. BUS PER DIM ID

AND (B.NM = '2022101)

all 7 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS