runtime error while running the code

[srinivasvinay]

i have three tables viz log,pln,master in excel

My query :

SELECT master.turnover, 
   master.major,
   master.minor,
   MASTER.BOQ,
   sum(pln.qty), 
   sum(log.qty)
FROM master, pln, log 
WHERE master.masid = pln.masid 
   AND pln.masid=log.masid 
GROUP BY master.turnover, 
   master.major,
   master.minor,
   MASTER.BOQ

i getting runtime i explicit mention join type or getting wrong valves in query result.

[zmbd]

Where did you get this SQL from?

Refering to your reformated code block:
Line 5 and Line 6 require an alias
Line 8 your where clause should be grouped
The spacing is required, in that you can not run all of the lines togeither as you had it.

So, your reworked SQL should be:

SELECT master.turnover, 
   master.major,
   master.minor,
   MASTER.BOQ,
   sum(pln.qty) As SumOfPlnQty, 
   sum(log.qty) As SumOfLogQty
FROM master, pln, log 
WHERE (((master.masid)=pln.masid) 
   AND ((pln.masid)=log.masid)) 
GROUP BY master.turnover, 
   master.major,
   master.minor,
   MASTER.BOQ;