troubleshooting Question

MySQL Syntax

Avatar of Richard Korts
Richard KortsFlag for United States of America asked on
MySQL Server
1 Comment1 Solution478 ViewsLast Modified:
What is wrong with this syntax?

SELECT lname, number, comm from `ol_res_discount` o, fname, email, street from resv r where r.confno = o.confno

The MySQL Error message is:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from resv r where r . confno = o . confno  LIMIT 0, 30' at line 1

Table structures attached.
ol-res-discount.jpg
resv.jpg
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros