Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lovecode

  1. lovecode

    SQL Query Help

    Thanks PHV again. That did it.
  2. lovecode

    SQL Query Help

    Thanks PHV, that worked. Appreciate it. Question 2: Now I want to modify that query so it returns all the records from Table1 and returns the associated records from Table2 if there is no associated record in Table2, it will still return the record from Table1. With the current query it...
  3. lovecode

    SQL Query Help

    Thanks for your suggestion. When trying to execute it via ADO it is throwing an error "syntax error in FROM clause". Tried it in MS Access query editor and and the same error.
  4. lovecode

    SQL Query Help

    I have following two tables: Table1: ------- ID Name Table2: ------- OwnerID Address1 Address2 Address3 Table1.ID = "100" and the corresponding address record in Table2 is Table2.OwnerID = "C100". So if Table1.ID = "200" then Table2.OwnerID = "C200" and so on. So the OwnerID field in...
See more

Part and Inventory Search

Back
Top