Updates/Inserts in Outer Join Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Venus - 26 May 2005 22:10 GMT

My form is based on a query. I want to display all employee hours whether
Invoice has been received or not. If invoice is not there, then my form
should display blank fields. When new invoices come I need to update the
invoice fields and create a records in the invoice table. Is it possible to
do this?

Reply to this Message

Michel Walsh - 31 May 2005 15:05 GMT

Hi,

With Jet (dot-mdb file), use an outer join. Jet allows to update the
unpreserved side by appending a record, in that case. MS SQL Server does not
allow that, on the other hand.

SELECT a.*, b.*
FROM employee As a LEFT JOIN bills as b
ON a.employeeID = b.employeeID

can be tried, as example.

Hoping it may help,
Vanderghast, Access MVP

> My form is based on a query. I want to display all employee hours whether
> Invoice has been received or not. If invoice is not there, then my form
> should display blank fields. When new invoices come I need to update the
> invoice fields and create a records in the invoice table. Is it possible
> to
> do this?

Reply to this Message