Greetings,
I'm very new to Mysql and am trying to work with my first multi-table database project. Here are my two table descriptions. I'm trying to get the correct syntax for a sql query to do the following. Display Ticket.Ticketnum,Ticket.Priority,Ticket.Title,Ticket.Status. I assume the customer does not know the CustomerID but only their email address (actually I'm parsing this with an email processor and passing the senderemail to it. Anyway, I know what Customer.Email is. The common field is CustomerID between the two tables. Can someone help me out? +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | CustomerID | int(5) | | PRI | NULL | auto_increment | | Email | varchar(40) | | | | | | FirstName | varchar(40) | | | | | | LastName | varchar(40) | | | | | | Title | varchar(40) | | | | | | Company | varchar(40) | | | | | | Address1 | varchar(40) | | | | | | Address2 | varchar(40) | | | | | | City | varchar(40) | | | | | | State | varchar(40) | | | | | | Zip | int(5) | | | 0 | | | phonedaytime | varchar(10) | YES | | NULL | | | phoneevening | varchar(10) | YES | | NULL | | | phonecellular | varchar(10) | YES | | NULL | | | phonepager | varchar(40) | YES | | NULL | | | domain | varchar(40) | | | | | | username | varchar(20) | | | | | | passwd | varchar(15) | | | | | | ContractNum | int(10) | | | 0 | | mysql> Describe Ticket; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | TicketNum | int(10) | | PRI | NULL | auto_increment | | CustomerID | int(5) | | | 0 | | | Priority | int(1) | | | 0 | | | Status | varchar(30) | | | | | | Title | varchar(60) | | | | | | ProblemSum | longtext | YES | | NULL | | | SupportID | int(5) | YES | | 0 | | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
