I would like to query a table, where i need 2 columns meet certain criteria, as an example, a table like below:

```
LastName FirstName Age address
LN1      FN1        18  ADD1
LN2      FN1        20  ADD2

```

Now I want to extract 1st address like below:

```
select * from mytable
where LastName in 'LN1' and FirstName in 'FN1' 

```

Can I use such a condition:

```
where (LastName, FirstName) in (LN1,FN1)

```

please kindly help. thanks.