SEELECT t1.* FROM ticket t1,customer t2 WHERE t1.customerid=t2.customer.id AND t2.email='[EMAIL PROTECTED]'
On Sat, 2002-12-21 at 16:52, Jim Hankins wrote: > 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 > -- Adolfo Bello <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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