Table TOY has columns named ID$,$ ToyName, Type, Manufacturer and table MANUFACTURER has columns named ID$,$ ManufacturerName. Will this query run?

Select ID$,$ ToyName, Type, ManufacturerName from TOY, MANUFACTURER where Manufacturer $=$ ID;