I think I am missing something obvious. I have a query to populate a form of invoices. One field is a restaurantid, which I want to pull the name associated with the id. It seems simple, but is not acting like I think it should. Is my structure a mess? What else would be helpful?
SELECT Invoices.*, Restaurant.RestoName
FROM Restaurant INNER JOIN Invoices ON Restaurant.RestoId = Invoices.RestaurantID;