Help with a join query

Hi all, I'm trying to do the following. I have three table: Table a has address information: address_id | City | State | Zip 1Austin TX 78758 2 Dallas TX 77000 3 Galveston TX 77550 Table b has information about the location: address_id | Location_id | Location_name 11The Pla

RE: Order by price?

if your curious. Best, Yoed -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 12:28 PM To: Yoed Anis; [EMAIL PROTECTED] Subject: Re: Order by price? At 12:14 -0500 4/29/04, Yoed Anis wrote: >I'm having trouble with this query: >SELEC

RE: Order by price?

#x27;ll work :-) Thanks guys, Best, Yoed -Original Message- From: Robert J Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 12:23 PM To: Yoed Anis; [EMAIL PROTECTED] Subject: Re: Order by price? Yoed Anis wrote: >I'm having trouble with this query: >SELECT >

Order by price?

esults: $90.44 $79.94 $50.10 $48.33 (with the max result 208 for instance at the 3rd from very bottom, 110 is at very bottom) Any help in solving this would be greatly appreciated. Thanks, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: SUM same field twice in one SELECT?

se. Hope this helps, Yoed -Original Message- From: Kristian Niemi [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 12:25 AM To: [EMAIL PROTECTED] Subject: SUM same field twice in one SELECT? Hi, I've just started to dabble with MySQL, creating a database as much for ac

RE: Is it possible to get a timestamp from the server ?

Yea do a search on the mysql.com web site for "date functions" (or just click here http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html ) its loaded with many examples and descriptions of useful functions. Built in date calculations are one thing I really enjoy with mysql.

Ram to Processor ratio

ly this will be an interesting discussion. Best, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Selecting a Column

;; But I don't know what command I'm looking for and all my searchs have come up fruitless. Plz CC this to my address if you reply. Thanks, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Order by umm OR?

ype tables when that happens I don't know a work around for that either. Best, Yoed -Original Message- From: Kevin Fries [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 10:59 AM To: 'Yoed' Subject: RE: Order by umm OR? Wow. Thousands of items in your IN cl

Order by umm OR?

s would be like: Row | id| name --- 0 | 3 | Joe's Co 1 | 1 | Buymart 2 | 7 | The big evil As it is the results returns it like id 1, then 3, and 7. Thanks for your help guys, Best, Yoed -- MySQL General Mailing List For list archiv

Search WHERE SUM

-07 2 | 3 | 2003-05 3 | 1 | 2003-06 3 | 1 | 2003-05 I want the query to return id 1 and 2 as the sum of their totalsales is smaller then 2. Thanks for your help, Best, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Interesting Problem

of errors, and I'm not very fimilar with JOIN and SQL and how that works. My idea was to create two querys, but the results in somesort of array, and then order the array by date... I was wondering though if this is a good efficient way or if you guys have any better suggestions as to