Question: Help! im sure what is wrong with my query im getting this message below. plesse herm me fugure out whats wrong with my query. SELECT

Help! im sure what is wrong with my query im getting this message below. plesse herm me fugure out whats wrong with my query.

SELECT DISTINCT tblPAandPB.P_B, tblPAandPB.P_A, DO_RS_P.REPLACNG_PT_NR AS P_Z INTO tblPZandPA

FROM tblPAandPB LEFT JOIN

(DO_RES_P ON tblPAandPB.P_A = DO_RES_P.P_NR INNER JOIN

DO_PNG_P_AREA on DO.RES_P.P_NR = DO_PNG_P_AREA.SM_P_NR) ;

Help! im sure what is wrong with my query im getting this

Syntax error in JOIN operation. Syntax error in JOIN operation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* Also by Marcus...

Q:

Algorithms in Artificial Intelligence (or, the old name: Introduction to Algorithmic Decision Making) Part 1 Based on slides by David Sarne and Lirong Xia Course Tentative Schedule Introduction...

Q:

Robin Mosier had just returned from her psychology class and was anxious to tell her roommate about an idea she had. Julie Hansen had taken the same class the previous semester, so Robin was hopeful...

Q:

Hello experts, I need help with this. I need a company that is very well known as I have to use the same company each week and if I need help Im sure I will not have the same tutor each week Each...

Q:

Martina Bavros operates a gift and framing shop as a sole proprietorship. Shefounded the business 11 years ago when her last child started school. From a small,part-time operation, Fancy Framed has...

Q:

Martina Bavros operates a gift and framing shop as a sole proprietorship. Shefounded the business 11 years ago when her last child started school. From a small,part-time operation, Fancy Framed has...

Q:

Stephen impresses both his bosses and the company's employees while serving as host of the meeting. During his hosting duty, he is able to accomplish multiple goals such as inspiring the workers,...

Q:

the last picture is a continuation from the forth one (yes its a big table that you have to fill out, its blank on purpose), pls help. im sure there are more tables to fill out according to the...

Q:

I need some help, I'm sure I used the correct formulas yet the results are somehow wrong Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). For...

Q:

PaRT 1: Identify an organization or group in NYC that is using community organizing to advocate for an issue that you are concerned about. Go to the organization's website and identify how the...

Q:

Find the area of a region bounded above by two different functions Question Calculate the area, in square units, bounded above by f(x) = x + 8x + 16 and g(x)= 8x + 80 and bounded below by the x-axis...

Q:

Distinguish between outsourcing, global sourcing, and offshoring.

Q:

A manufacturing company gets quotes from each supplier and allocates the purchase order to the company which quotes the lowest price with the expected quality. Are there any additional costs that are...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

(Appendices) What are sales returns? Why do sales returns occur? LO86

Q:

(Appendices) Dave, age 58, is the owner of a small firm that sells window blinds and cleans carpets. The company provides health insurance for seven employees. The wife of one employee has breast...

Q:

(Appendices) Copy the ingredients from the labels of the following products: (a) deodorant, (b) liquid cleaning product, (c) bug spray, and (d) breakfast cereal. Do any of the labels carry warnings?...