multiple tables for details page
Ray helped me out today during a paid support session with adding data from two tables on a details page. He joined the "toys" table with the "MIT" table to bring in the "MIT_Link" with this code:
$query_rsDetails = sprintf("SELECT toys.*, MIT_Link FROM toys LEFT OUTER JOIN MIT ON MIT.MIT_ID = toys.MIT_ID WHERE productID = %s", GetSQLValueString($colname_rsDetails, "int"));
Now, I need to add data from two other tables - a "dc_Link" from a table called "dcAdaptor" and a "footpad_Link" from a table called "footpad". I cannot figure out how to incorporate those new elements in the code.