Re: Help with a SELECT Statement

2004-06-03 Thread Josh Trutwin
On Thu, 3 Jun 2004 22:36:55 +0100 "Andrew Dixon" <[EMAIL PROTECTED]> wrote: > Hi Everyone. > > I have the following SELECT statement the get information from two > tables. The statement only works when it finds a value for the > image_archive.circuit value in the circuits table. However, not all

Help with a SELECT Statement

2004-06-03 Thread Andrew Dixon
Hi Everyone. I have the following SELECT statement the get information from two tables. The statement only works when it finds a value for the image_archive.circuit value in the circuits table. However, not all entries in the database has a value in the this field, some are set to 0 as the circui

RE: Need help with a SELECT statement across 3 tables

2004-02-04 Thread Brandon Ewing
I think I should be able to claim SQL as a second language - you can say so much with it! Brandon Ewing -Original Message- From: Dominique Plante [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:43 PM To: 'Brandon Ewing' Subject: RE: Need help with a SELECT statement acro

Need help with a SELECT statement across 3 tables

2004-01-23 Thread Brandon Ewing
Isn't it great when you've got this pretty picture in your head about what you want SQL to do for you, but aren't sure how to write it down? I've got 3 tables, they are: server - a table that tracks all of our servers, including os, where they are, access details, etc update_track - a table tha