Syntax error (missing operator) in query expression

Question

0.00/5 (No votes)

See more:

Sir i have following From in Query

SQL

Syntax error (missing operator) in query expression  'Laptopdeatils on Laptopdeatils.Jobid=JobDetails.Jobid Inner Join CustomerMaster  ON JobDetails.Jobid=CustomerMaster.Jobid  INNER JOIN  Partmaster on Partmaster.Jobid=CustomerMaster.Jobid'

you Can see my query bellow

SQL

Select  JobDetails.Jobid
       ,JobDetails.JobDate
       ,JobDetails.Collid
       ,JobDetails.warrentytype
       ,JobDetails.ProductFrom
       ,JobDetails.Problem
       ,JobDetails.PhysicalConditon
       ,JobDetails.Enginnerfeddback
       ,Laptopdeatils.Model
       ,Laptopdeatils.LSrno
       ,CustomerMaster.CName
       ,CustomerMaster.Contactperson
       ,CustomerMaster.Address
       ,CustomerMaster.Email
       ,CustomerMaster.Phoneno
       ,JobDetails.Jobid
       ,JobDetails.JobDate
       ,JobDetails.Collid
       ,JobDetails.warrentytype
       ,JobDetails.ProductFrom
       ,JobDetails.Problem
       ,JobDetails.PhysicalConditon
       ,JobDetails.Enginnerfeddback 
FROM JobDetails 
INNER JOIN Laptopdeatils ON Laptopdeatils.Jobid=JobDetails.Jobid 
INNER JOIN CustomerMaster ON JobDetails.Jobid=CustomerMaster.Jobid  
INNER JOIN Partmaster ON Partmaster.Jobid=CustomerMaster.Jobid 

WHERE JobDettails.Jobid=1;

please reply this question

Posted 23-Mar-12 20:16pm

mub123

Updated 24-Mar-12 0:52am

Oshtri Deka

v3

Add a Solution

Comments

Oshtri Deka 24-Mar-12 6:52am

Edit: query readability.

2 solutions

Add a Solution

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

Saral S Stalin · Answer 1 · 2012-03-25T18:21:00

Solution 2

There is an additional 't' in the JobDettails

SQL

WHERE JobDettails.Jobid=1;

Dont worry, everybody makes such mistakes

Posted 25-Mar-12 18:21pm

Saral S Stalin

Ganesan Senthilvel · Answer 2 · 2012-03-24T02:20:00

Solution 1

Guess is 'Jobid' field is the root cause for this issue. Because, if the field is defined as text you must use the 's even if the value is a number.

What is the data definition for Jobid column in all tables (JobDetails, Laptopdetils, CusomterMaster, Partmaster)

Posted 24-Mar-12 2:20am

Ganesan Senthilvel

Syntax error (missing operator) in query expression

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Syntax error (missing operator) in query expression

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us