Question: hello i got this error from this sql queries canbyou help me. [23:1] Failed in 0 s. [Exception, Error code 30,000, SQLState 42x05] Table/View 'M'

![me. [23:1] Failed in 0 s. [Exception, Error code 30,000, SQLState 42x05]](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f300f1dae36_52166f300f14e67e.jpg)

hello i got this error from this sql queries canbyou help me.
[23:1] Failed in 0 s. [Exception, Error code 30,000, SQLState 42x05] Table/View 'M' does not exist. Line 23, column 1 Execution finished after 0.011 s, 9 errors occurred. Activ [23:1] Failed in 0 s. CREATE TABLE CUSTOMER( CustNo int, Lname varchar(20),Fname varchar(20), branch No int, code int, LoanNo int, Loantype varchar(50), Loanintrest double); INSERT INTO CUSTOMER( CustNo, Lname ,Fname ,branchNo , code , LoanNo, Loantype , Loanintrest) VALUES (1,'SINGH', 'DEV', 105,255,123,'Car Loan, 11%); INSERT INTO CUSTOMER( CustNo, Lname ,Fname ,branchNo , code , LoanNo, Loantype , Loanintrest) VALUES (5,'SINGH', 'DEN', 145,256,124,'Housing Loan',13%); SELECT *FROM CUSTOMER; CREATE TABLE LOAN(LoanNo int, CustNo int, Loan_type varchar(50), BranchNo int, code int); INSERT INTO LOAN(LoanNo, CustNo, Loan_type ,Branch No, code ) VALUES (125,25,'Car Loan',25,255); SELECT *FROM LOAN CREATE TABLE BANK_BRANCH(LoanNo int, Loan_type varchar(80), CustNo int, Loanintrest double, Cust_name varchar(50)); INSERT INTO BANK_BRANCH(LoanNo, Loan_type, CustNo, Loanintrest, Cust_name ) VALUES (25,'Car Loan, 20,11%,'DEV SINGH'); SELECT *FROM BANK_BRANCH; ULV, IUU, LUU, IZU, VUI LUUIT,II), INSERT INTO CUSTOMER( CustNo, Lname ,Fname ,branchNo , code , LoanNo, Loantype , Loanintrest) VALUES (5,'SINGH', 'DEN', 145,256,124,'Housing Loan',13%); SELECT *FROM CUSTOMER; CREATE TABLE LOAN(LoanNo int, CustNo int, Loan_type varchar(50), BranchNo int, code int); INSERT INTO LOAN(LoanNo, CustNo, Loan_type ,BranchNo, code ) VALUES (125,25,'Car Loan',25,255); SELECT *FROM LOAN CREATE TABLE BANK_BRANCH(LoanNo int, Loan_type varchar(80), CustNo int, Loanintrest double, Cust_name varchar(50)); INSERT INTO BANK_BRANCH(LoanNo, Loan_type, CustNo, Loanintrest, Cust_name ) VALUES (25,'Car Loan', 20,11%,'DEV SINGH'); SELECT *FROM BANK_BRANCH; SELECT Cust_name, LoanNo, Loan_type, Loanintrest FROM CUSTOMER inner join LOAN m on LoanNo_id = CustNo_id inner BANK_BRANCH d on d. Loanintrest_id m.Loan_type_id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
