Query Help

[Guest]

I have one query which contains names and addresses of all consultants for
each project.

I have a table which contains my firm's name and address.

I want to create a query which will result in my firm's name and address
shows up for every project.

It seems to me this is conceptually easy but I can't seem to get it right.

 

[Guest]

If the firm's table contain only one record that include the name and the
address, you can simply add it to the query that include the project table
with no link between them

Select Project.Id, Project.Name , Firm.Name, Firm.Address
From Project, Firm