Updates/Inserts in Outer Join Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top