How do I solve this kind of error please

Question

1.00/5 (1 vote)

See more:

CREATE VIEW buy
As
select Fname,Lname,Branch_Name,Hrs
from customer,Branch,Buysfrom
where Branch.Branch_id=Buysfrom.Bid
And Branch.Branch_id=customer.Customer_id2
select *
from buy

What I have tried:

Msg 156, Level 15, State 1, Procedure buy, Line 7 [Batch Start Line 101]
Incorrect syntax near the keyword 'select'.

Completion time: 2022-12-13T20:02:23.1563244+02:00

Posted 13-Dec-22 7:03am

Noran Azab

Updated 14-Dec-22 0:15am

Richard Deeming

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-12-13T07:45:00

Solution 1

You can't create a view using two separate SELECT statements - they each create a table and that confuses things.

Think about wnat exactly you want the view to do, probably you want a UNION between them.

Posted 13-Dec-22 7:45am

OriginalGriff

Comments

Dave Kreskowiak 13-Dec-22 14:18pm

Even better, the second SELECT is grabbing all the records from the very view he's creating!

OriginalGriff 13-Dec-22 14:52pm

So it is ... I didn't notice that!

Richard Deeming · Answer 2 · 2022-12-14T00:15:00

Assuming you meant to create the view, then select everything from it, you need two separate statements.

You'll also want to use the proper JOIN syntax, rather than the ancient and obsolete pre-ANSI-92 syntax you've currently got.

SQL

CREATE VIEW buy
As
    SELECT 
        Fname,
        Lname,
        Branch_Name,
        Hrs
    FROM 
        customer
        INNER JOIN Branch ON Branch.Branch_id = customer.Customer_id2
        INNER JOIN Buysfrom ON Buysfrom.Bid = Branch.Branch_id
GO
select *
from buy