Re: Help with Joins

2004-05-20 Thread Peter Brawley
- From: Robert Reed To: [EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:12 PM Subject: Help with Joins Greetings. I have a table that contains procedures and a table that contains forms. Each procedure may have 1 or more forms or it may have no associated forms. Each

Re: Help with Joins

2004-05-19 Thread Michael Stassen
Robert Reed wrote: Greetings. I have a table that contains procedures and a table that contains forms. Each procedure may have 1 or more forms or it may have no associated forms. Each form may be relevant to more than 1 procedure. The procedure table has 1 entry per procedure. The forms table m

Help with Joins

2004-05-19 Thread Robert Reed
Greetings. I have a table that contains procedures and a table that contains forms. Each procedure may have 1 or more forms or it may have no associated forms. Each form may be relevant to more than 1 procedure. The procedure table has 1 entry per procedure. The forms table may have more than

Re: Help with Joins

2002-12-21 Thread Adolfo Bello
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 desc

Help with Joins

2002-12-21 Thread Jim Hankins
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 t

Help With Joins

2002-08-13 Thread Calvin Hill
I am having some problems getting multiple joins to work. I have the following code: mysql> select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO -> from customers left join work_order -> on (customers.customer_id=work_order.customer_id) -> wher