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.