Page 1 of 1

select statemnt

Posted: Fri Oct 25, 2002 5:41 am
by ridwan
I am trying to figure out a select statement which will get info from two colums, this is what i mean :

SELECT * FROM table1 WHERE column1 = 'stuff' AND column2 = 'morestuff'

It shouldn't be 2 hard but I've looked all over and can't seem to find anything about it

thanks all

Posted: Fri Oct 25, 2002 5:54 am
by twigletmac
Is that statement not working for you - I can't see anything wrong with it? What exactly are you trying to do and what problems are you having doing it?

Mac

it just doesn't show any info

Posted: Fri Oct 25, 2002 7:05 am
by ridwan
i have these 2 columns in my table one is a celled section and the other subsection so my select statement works by seeing whether the necessary value is in both columns and if it is, it will display the info in one of the other columns.

if you need me to give you the code just let me know and I will, it's only about ten lines in all.

thanks