-
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
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
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
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
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
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
