RE: Join help

2006-06-14 Thread Tim Lucia
You want a LEFT (OUTER) JOIN, which will return nulls for the columns if no match on the join expression. -Original Message- From: Paul Nowosielski [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 4:44 PM To: mysql@lists.mysql.com Subject: Join help Dear All, I'm working on a

Re: JOIN help

2004-09-08 Thread Wesley Furgiuele
Robb: http://dev.mysql.com/doc/mysql/en/JOIN.html I am assuming all the information you need is student name + city name. SELECT * FROM StudentTable AS s, CityTable AS c WHERE s.CityID = c.CityID Wes On Wed, 8 Sep 2004 19:55:29 -0500, Robb Kerr <[EMAIL PROTECTED]> wrote: > Trying to get my mind

Re: join help: i am lost

2003-01-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank -- ...and then Frank Peavy said... % % >Even so, that still doesn't answer the question of how to have data of % >different magnitude in the same table. If I have one class with one % >person and another with two people, how would I have a sin

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
Even so, that still doesn't answer the question of how to have data of different magnitude in the same table. If I have one class with one person and another with two people, how would I have a single record for each which lists the client(s)? Easy, Your scheduling query results, as I said:

Re: join help: i am lost

2003-01-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank -- ...and then Frank Peavy said... % % David, % Just some thoughts.. % See my comments below... Thanks! % % >A scheduling, or a booking, eventually has to have a class type (private % >or one of many groups -- so I suppose I could simply ma

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
David, Just some thoughts.. See my comments below... A scheduling, or a booking, eventually has to have a class type (private or one of many groups -- so I suppose I could simply make a group class type 'private' and that type has only one slot), an instructor, a place, a time slot, and the clien

Re: join help: i am lost

2003-01-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank, et al -- ...and then Frank Peavy said... % % David, % I am unsure if I followed your example completely, but maybe this might % help. Not knowing your complete database structure, I am unsure if my % comments will be entirely valid but here

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
David, I am unsure if I followed your example completely, but maybe this might help. Not knowing your complete database structure, I am unsure if my comments will be entirely valid but here goes. I think you could achieve your goal if you think of your groups as containing one or many clients.

Re: Join help.

2002-12-05 Thread Scott Pippin
>Is there a good tutorial somewhere on the join command. No matter what I do >it just doesn't work. Obviously I'm doing something wrong, but the MySQL >manual just doesn't help at all. Try this link. http://www.devshed.com/Server_Side/MySQL/Join/page1.html One of the best books for understanding

Re: JOIN Help!

2001-02-11 Thread Bob Hall
>Hi All, > >I have a JOIN statement: > >SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON >d.domain_id=b.domain_id >WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C' >GROUP BY domain_name > >In addition to the fields this statement returns, I would also