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
select statemnt
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
it just doesn't show any info
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
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