26, 2007 10:06 AM
*To:* [EMAIL PROTECTED]
*Cc:* Micah Stevens; mysql@lists.mysql.com
*Subject:* Re: Sorting Problem
Try:
select * from business_names
left join business_entries using (bus_id)
left join business_categories using (bcat_id)
where business_categories.bcat_id=17
order by business_nam
PROTECTED]
Cc: Micah Stevens; mysql@lists.mysql.com
Subject: Re: Sorting Problem
Try:
select * from business_names
left join business_entries using (bus_id)
left join business_categories using (bcat_id)
where business_categories.bcat_id=17
order by business_names.organisation
You must have
Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 1:10 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
The query using JOIN syntax (you can read about this in the documentation)
describes the interelationship between the three tables you described, in
th
@lists.mysql.com
Subject: Re: Sorting Problem
The query using JOIN syntax (you can read about this in the documentation)
describes the interelationship between the three tables you described, in
this way you can select information based on a WHERE clause as it relates
to the category table, while
http://www.softtools.com
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 25, 2007 9:23 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
evens [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 25, 2007 9:23 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
left join categories using (categoryID)
where cat
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
left join categories using (categoryID)
where category.name = 'something'
order by businesses.name ASC
On 03/25/2007 12:40 PM, Sid Price wrote:
Hello,
I have a MySQL database design that provides
H Bartel wrote:
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
++--+--+---+---+
table programm
++--+---++
| id | date | stage | artist |
++--+---++
