baig772 baig772 - 1 year ago 88
MySQL Question

What is wrong in this query?

This query:

SELECT tbl_deliverable.*, user_to_deliverable.*
where = user_to_deliverable.d_id

returns this error from phpmyadmin:

- 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
'where = user_to_deliverable.d_id'
at line 1


Answer Source

You forgot your "from tables" in the SQL:

SELECT tbl_deliverable.*,   user_to_deliverable.*
from   tbl_deliverable,     user_to_deliverable
where = user_to_deliverable.d_id

Just add:

from tbl_deliverable, user_to_deliverable
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download