Search results

  1. A

    update query and LEFT OUTER JOIN

    BH Hi all, I'm trying to use the below c# syntax to update a single row in my table. tenantTableAdapter.Update(new[] { (tenantBindingSource.Current asDataRowView).Row }); However, when I run the above code I get an exception, saying "Data type mismatch in criteria expression." I know it's...
  2. A

    Update statement for a OUTER JOIN Select Statement.

    BH jdraw, thanks for your reply. I would like to update all fields from the SELECT statement. Thanks Aron
  3. A

    Update statement for a OUTER JOIN Select Statement.

    BH Hi, I have the following Select Statement: SELECT Tenant.ID, Tenant.[First Name], Tenant.[Last Name], Tenant.Address, Tenant.City, Tenant.State, Tenant.Zip, Tenant.[Home Phone], Tenant.[Cell Phone], Tenant.[Work Phone], Tenant.[Rented Unit]...
  4. A

    join 3 tables

    Hi, I have 3 simple tables as follows: Table1: OwnerID, Owner_LastName, Table2: TenantID, Tenant_LastName, Table3 ID, Date, Amount, OwnerID, TenantID I need query to display ALL the rows from Table3 and show columns of Owner_LastName and Tenant_Lastname. However, I want the rows...
Back
Top Bottom