Link to home
Start Free TrialLog in
Avatar of javalite
javalite

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of ALaRiva
ALaRiva
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of javalite
javalite

ASKER

Can't believe I did that.. :)

Thanks!!