query
Posted: Tue Sep 20, 2005 3:03 pm
I need to join all the information of 2 tables into one query
Here are the table names with all the fields so, if you can help me to write a proper query
Table Name
orders
Fields
orders_id, * Primary KEY
customers_id,
customers_name,
customers_company,
customers_street_address,
customers_suburb,
customers_city,
customers_postcode,
customers_state,
customers_country,
customers_telephone,
customers_email_address,
customers_address_format_id,
delivery_name,
delivery_company,
delivery_street_address,
delivery_suburb, delivery_city,
delivery_postcode, delivery_state,
delivery_country, delivery_address_format_id,
billing_name, billing_company,
billing_street_address,
billing_suburb, billing_city,
billing_postcode, billing_state,
billing_country,
billing_address_format_id,
payment_method,
cc_type,
cc_owner,
cc_number,
cc_expires,
last_modified,
date_purchased,
orders_status,
orders_date_finished,
currency,
currency_value,
Table Name
orders_products
Fields
orders_products_id, Primary Key
orders_id, *Link KEY
products_id,
products_model,
products_name,
products_price,
final_price,
products_tax,
products_quantity,
Here are the table names with all the fields so, if you can help me to write a proper query
Table Name
orders
Fields
orders_id, * Primary KEY
customers_id,
customers_name,
customers_company,
customers_street_address,
customers_suburb,
customers_city,
customers_postcode,
customers_state,
customers_country,
customers_telephone,
customers_email_address,
customers_address_format_id,
delivery_name,
delivery_company,
delivery_street_address,
delivery_suburb, delivery_city,
delivery_postcode, delivery_state,
delivery_country, delivery_address_format_id,
billing_name, billing_company,
billing_street_address,
billing_suburb, billing_city,
billing_postcode, billing_state,
billing_country,
billing_address_format_id,
payment_method,
cc_type,
cc_owner,
cc_number,
cc_expires,
last_modified,
date_purchased,
orders_status,
orders_date_finished,
currency,
currency_value,
Table Name
orders_products
Fields
orders_products_id, Primary Key
orders_id, *Link KEY
products_id,
products_model,
products_name,
products_price,
final_price,
products_tax,
products_quantity,