Execute On Query To Select Data From Multiple Tables
Posted: Tue May 12, 2009 7:06 am
Hi! Everybody.
I have 6 table i want to select data from these table to execute one Query.
First Table movieitem attribute moviid
second table movieinformation attribut moviid
third table shop attribut shoppingcart against moviid.
fourth table shoppingcart take customer id against moviid.
fifthe table customer customer id against fourth customr id
sixth purchase against customerid
please execute query.
thanks
I have 6 table i want to select data from these table to execute one Query.
First Table movieitem attribute moviid
second table movieinformation attribut moviid
third table shop attribut shoppingcart against moviid.
fourth table shoppingcart take customer id against moviid.
fifthe table customer customer id against fourth customr id
sixth purchase against customerid
please execute query.
thanks