SQL select statement

logistic

Trying to figure out an SQL select statement that takes in a number and queries 2 fields for a match and provides all information if the match is correct.

I can query 1 field which works like so
select * from Table where CurrentPin = ?

How can i query 2 fields. Thought this would work but doesnt
select * from Table where CurrentPin = ? or PreviousPin = ?

Any ideas?

bren2002

Look up sql joins

s7ryf3925pivug

union two selects one for each criterion

FastFullBack

logistic wrote: »

Trying to figure out an SQL select statement that takes in a number and queries 2 fields for a match and provides all information if the match is correct.

I can query 1 field which works like so
select * from Table where CurrentPin = ?

How can i query 2 fields. Thought this would work but doesnt
select * from Table where CurrentPin = ? or PreviousPin = ?

Any ideas?

What exactly is not working with the OR statement? Based on the details you provided it should work fine.

Can you post the exact SQL?

beauf

logistic wrote: »

Trying to figure out an SQL select statement that takes in a number and queries 2 fields for a match and provides all information if the match is correct.

I can query 1 field which works like so
select * from Table where CurrentPin = ?

How can i query 2 fields. Thought this would work but doesnt
select * from Table where CurrentPin = ? or PreviousPin = ?

Any ideas?

Not sure what you are asking....

...to find where both fields are identical is an AND not an OR..
...you could just have CurrentPin = PreviousPin

if thats what you meant. hard to know.