Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

MySQL Syntax

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
Avatar of sammySeltzer
sammySeltzer
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