sqlite - Android select multiple records -

with query select record, want select record next id, should combine these 2 select, how can do?

string sql ="select _id, date, score, score1 points  score = '"+score_ricevuto+"' order date desc";  string sql ="select _id, score, score2  points score = '"+score_ricevuto+"'; 

like so:

select _id, date, score, score1, score2    points   score = '"+score_ricevuto+"'   order date desc";