<div>
Please can you tell us what you have done<br />
<br />
Also you gave zero feedback so how can one help you further?<br />
<br />
and this statement &quot;I would like to return all rows from Q1 whether or not there is data returned from Q2&quot;<br />
can be resolved by using a left join (or right join)
</div>


Please can you tell us what you have done

Also you gave zero feedback so how can one help you further?

and this statement "I would like to return all rows from Q1 whether or not there is data returned from Q2"
can be resolved by using a left join (or right join)

<div>
<div class="content wysiwyg-content">
I have written a query in Access which references two separate queries<br />
<br />
Q1 - List of current staff<br />
Q2 - List of activites carried out by staff<br />
<br />
I would like to return all rows from Q1 whether or not there is data returned from Q2 but i get a message saying invalid operation !<br />
<br />
Can anyone help<br />
<br />
Many thanks
</div>
</div>


I have written a query in Access which references two separate queries

Q1 - List of current staff
Q2 - List of activites carried out by staff

I would like to return all rows from Q1 whether or not there is data returned from Q2 but i get a message saying invalid operation !

Can anyone help

Many thanks

Access 2007 - Query Help

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.