Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Hi there,I've got a little problem. I need to join two tables both have the field "Product_ID" but the contents of the columns differ slightly. For example:Table 1Field: Product_ID Datum: 423 ...

I want to join tables based on more than one column. Is this possible? What is the syntax to do it?For example, here is a join using one column:SELECT au_fname, au_lname, titleFROM authorsINNER ...