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
Execute On Query To Select Data From Multiple Tables
Moderator: General Moderators
-
shafiq2626
- Forum Commoner
- Posts: 88
- Joined: Wed Mar 04, 2009 1:54 am
- Location: Lahore
- Contact:
Re: Execute On Query To Select Data From Multiple Tables
You'll want to do this by using joins. Here is a tutorial that will help you better understand mysql joins. Basically using a join you'll be able to grab specific data from multiple tables using the criteria you have above.
http://www.tizag.com/mysqlTutorial/mysqljoins.php
Hope this helps.
http://www.tizag.com/mysqlTutorial/mysqljoins.php
Hope this helps.