Re: [SQL] BirthDay SQL Issue

2005-10-05 Thread Kenneth Gonsalves
On Sunday 02 Oct 2005 4:02 am, brett wrote: > This is my first posting here, please forgive me if I make any > mistakes here. thought your question was dead simple. worked on the answer for hours at end. learnt a lot of sql, but couldnt solve it. Looks like a solution is out. All i can say is -

Re: [SQL] BirthDay SQL Issue

2005-10-05 Thread Andreas Kretschmer
brett <[EMAIL PROTECTED]> schrieb: > Hi there > > This is my first posting here, please forgive me if I make any > mistakes here. > > Ok > > I have the structure > > {CLIENTS} = Client ID, First Name, Surname, DOB, Address, Home Phone > No, Mobile Phone No > > As one relation / table (There

Re: [SQL] BirthDay SQL Issue

2005-10-05 Thread Richard Huxton
brett wrote: I need to be able to select two dates on my webby so I have a range of dates Then I want to be able to get, using some nifty query, everyone's birthday that falls between those two dates. So if someone's birthday was 04/09/79 it would return that tuple I have been stuck on this

[SQL] BirthDay SQL Issue

2005-10-04 Thread brett
Hi there This is my first posting here, please forgive me if I make any mistakes here. Ok I have the structure {CLIENTS} = Client ID, First Name, Surname, DOB, Address, Home Phone No, Mobile Phone No As one relation / table (There are several others in this db that are not related to this is