query help-multiple joins

2006-05-23 Thread mel list_php
Hi! I'm stuck with a join query 2 tables, term and relation, the first one with definition of terms the second one with the relations between them. CREATE TABLE `term` ( `term_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(250) default NULL, ) ENGINE=MyISAM DEFAULT

Re: query help-multiple joins

2006-05-23 Thread Johan Höök
Hi, I guess you should be able to do something like: SELECT t1.term_id, t1.name, r.type_id, t2.term_id, t2.name FROM term t1 LEFT JOIN relationTerm r ON r.term_id1 = t1.term_id LEFT JOIN term t2 ON r.term_id2 = t2.term_id /Johan mel list_php skrev: Hi! I'm stuck with a join query 2

Re: query help-multiple joins

2006-05-23 Thread mel list_php
help-multiple joins Date: Tue, 23 May 2006 13:16:33 +0200 Hi, I guess you should be able to do something like: SELECT t1.term_id, t1.name, r.type_id, t2.term_id, t2.name FROM term t1 LEFT JOIN relationTerm r ON r.term_id1 = t1.term_id LEFT JOIN term t2 ON r.term_id2 = t2.term_id /Johan mel list_php

Re: Help with Joins

2004-05-20 Thread Peter Brawley
: 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 form may be relevant

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

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

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

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

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

Help about joins

2001-08-27 Thread Jarkeborn Joacim
Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM

Re: Help about joins

2001-08-27 Thread Van
Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer

RE: Help about joins

2001-08-27 Thread Järkeborn Joacim
-Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: den 27 augusti 2001 11:01 To: Jarkeborn Joacim Cc: [EMAIL PROTECTED] Subject: Re: Help about joins Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I