[SOLVED] Grab data from different tables

[ShaolinF]

Hi Guys,

 

I have 3 tables and I want to derive certain columns from all three of them. See the tables below (The text highlighted in bold red are the columns I want to extract):

 

 

 

 

 

 

 

 

 

users table:

userid, name, contactNo, email, gender

 

purchase table:

purchaseid, userid, eventid, noOfTicketsPurchased, totalPrice, process_timestamp, pp_payment_status

 

event table:

eventid, eventName, TicketsOnSale, TicketPrice, setevent

 

 

[amites]

You would do well to study joins

 

you can find a great starting point at

http://www.tizag.com/mysqlTutorial/mysqljoins.php

 

if you come up with some code and have trouble getting it working post what you have and I'd be happy to help you