[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Need to resolve an ERROR on a Select Query!! Urgent!!

SELECT *.getItembyBranchbyUnits, F41021.LILOCN, F4102.LIPQOH, F4102.LIPBIN
FROM getItembyBranchbyUnits INNER JOIN F41021 ON getItembyBranchbyUnits.IMITM = F41021.LIITM
WHERE getItembyBranchbyUnits.IBMCU = F41021.LIMCU ;


I'm getting a syntax error on *.getItembyBranchbyUnits  
It says missing operand.
Do I have to list everyfield on the table getItembyBranchbyUnits  or is there a short cut on the select statement?

Thanks,
Nihal
0
javalite
Asked:
javalite
1 Solution
 
ALaRivaCommented:
you got it backwards.

Try:
getItembyBranchbyUnits.*

-Anthony
0
 
javaliteAuthor Commented:
Can't believe I did that.. :)

Thanks!!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now