SQL Querys

How do you write an "and" clause into a query.

I'm trying to get results from (2) colums in a table

Ex: Select * from table where blah1 and blah2 = output

Comments

  • : How do you write an "and" clause into a query.
    :
    : I'm trying to get results from (2) colums in a table
    :
    : Ex: Select * from table where blah1 and blah2 = output
    :


    Select * from dual
    where blah1 = var
    and blah2 = var;

    May be I don't understand the question.


  • try

    Select * from table where (blah1 & blah2) = output


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories