var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How would I go about joining these 4 tables?
table 1 CustomerIDPK, countryIDFK, stateIDFK, Cust_Name. Address
table 2 CustomerIDFK, Computer_Name
table 3 stateIDPK, state
table 4 countryIDPK, country
How would I make the join in order to display specific information from each table in a query? for example: cust_name, computer_name, state, country
one does not write a query "to display specific information from each table"
one writes a query to return data for a specific need
what specific data were you looking for? customers in africa who don't have a computer? states which have no customers? the number of customer computers in each country?
see, the permutations and combinations are endless, we cannot guess at what you want...
The data I would need returned would be
1. customer name
4. computer name for that customer
all this information spans over 4 tables
customer table has information such as customer name, address. etc.
country table has list with country name, etc.
ON table2.CustomerID = table1.CustomerID
ON table3.stateID = table1.stateID
ON table4.countryID = table1.countryID