Re: Newbie - SELECT Query Help

2004-03-03 Thread Egor Egorov
D F <[EMAIL PROTECTED]> wrote: > > I want to select a column twice but get the results > using two different conditions. > > SELECT tbl.colA, tbl.colA from tbl where tbl.info = B > (the first colA) and tbl.info = C (for the second > colA) > > I hope this makes sense. Could you describe more de

Newbie - SELECT Query Help

2004-03-02 Thread D F
hello, I want to select a column twice but get the results using two different conditions. SELECT tbl.colA, tbl.colA from tbl where tbl.info = B (the first colA) and tbl.info = C (for the second colA) I hope this makes sense. Thanks __ Do you Yahoo!? Yahoo! Se