How can I select multiple items for SQL?

Viewed 70

Does anyone know how to use SELECT in SQL for multiple objects. For example, I want to try to SELECT from Make and Model under a single method. I tried using SELECT Make, Model FROM car_basic WHERE Year IN (1985), but it only selects the former object.

public List<string> SearchYear()
{
    //chose 1985 as the year
    string sql = "SELECT Make FROM car_basic WHERE Year IN (1985)";
    List<string> select = _db.LoadData<string, dynamic>(sql, new { });
    return select;
}
public List<string> SearchYearContinued()
{
    //chose 1985 as the year
    string sql = "SELECT Model FROM car_basic WHERE Year IN (1985)";
    List<string> select2 = _db.LoadData<string, dynamic>(sql, new { });
    return select2;
}
0 Answers
Related