Sorry i am new to SQL and was wondering if there exists a means to returns a default value for record that do not exist. e.g. select * from tables where col1 in (1,2,3) in this case 2 does not exists in the table
| col1 | fruit |
|---|---|
| 1 | apples |
| 3 | bananas |
| 2 | sorry this value does not exist in the table |