Unanswered: 'select ... where ... ' returns only one row
Hi. When I execute the code below I get only one row returned, however actually there are more than one row that should be returned. If I replace column names with '*' to select all, it works fine, but i need to join additional table as you see.
SELECT Bills.ID, Bills.BillNumber, Vendors.Name, Bills.Date, Bills.DueDate, Bills.Amount, Bills.Description
FROM Bills INNER JOIN Vendors ON Bills.ID = Vendors.ID WHERE Bills.Paid = 'False'