If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

data base query

Hi all.

I have two tables: products and products_description. They have different number of columns. I want to select information from both tables with a single query. When I try the query below, I get a 1064 error. Can you help?

You're not specifying which columns you want, for starters.
You also need to specify how to join the tables.
Read the MySQL docs on JOINs for more info.

For example
(not likely to work "as-is" -
e.g., this assumes that the records in Product have "matching" rows in product_description and that they share ID numbers -
plus, I don't know any of your column names aside from ID -
if you want a more specific answer, share your table schema):

This thread has been closed due to age. If anyone wants information on it, please start a new thread. Feel free to link back to this one if you feel it contains information important to your new thread.