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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Syngin

    Joining the same table twice in one recordset under MySQL

    Hello again Rudy, Wow you're just everywhere. Cheers
  2. Syngin

    Joining the same table twice in one recordset under MySQL

    Hmm, this looks like it might be the way to go. After running an addapted version of this query, I run into a syntax problem: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'case ) as sales1...
  3. Syngin

    Joining the same table twice in one recordset under MySQL

    Nope, not that easy. I've tried all manner of joins without luck (by this I mean I may get sales figures but they aren't correct) Left Joins, Inner Joins, Right Joins, Prayer Joins etc. nothing correct hehe
  4. Syngin

    Joining the same table twice in one recordset under MySQL

    I’m trying to join 2 instances of the same table with separate criteria and am running into some serious problems. Essentially, it’s a comparison of an invoice table based on different time criteria. A boiled down version of the table looks like this: Table name: Invoices inv_number (int)...

Part and Inventory Search

Back
Top