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!

  • Congratulations TouchToneTommy 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 MarvinTheAndroid

  1. MarvinTheAndroid

    Difficult Multi-table Query with OLEDB

    YOU ARE THE MAN!!! Sorry, I am really excited- I having been trying to figure this out since last week and I was at wit's end. It's not often Google fails me, but thankfully tek-tips and PHV were here!!!!!!!!!! Works perfectly! I can now use this to improve our company intranet site as well.
  2. MarvinTheAndroid

    Difficult Multi-table Query with OLEDB

    OK, I tried it again, and it did not work. I keep getting this error: "Syntax error in JOIN operation" Do OLEDB JET connections support LEFT or RIGHT JOINS?
  3. MarvinTheAndroid

    Difficult Multi-table Query with OLEDB

    Hi, I'm not sure :) It looks like you abbreviated some of the table names. I'm not sure what this is : "(Servers S INNER JOIN Users U ON S.Owner=U.ID)" What is the S after Servers and the U after Users for? I changed it to "Servers S INNER JOIN Users U ON Servers.Owner=Users.ID" but it...
  4. MarvinTheAndroid

    Difficult Multi-table Query with OLEDB

    Hi, I have spent the last several days trying to figure out how to do a particular query, and I am ready to pull my hair out. I will try to explain in as much detail as possible what I am trying to do. OK, First off I am using Visual Studio 2003 to write a ASP.NET (VB.NET Code) web page that...

Part and Inventory Search

Back
Top