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!

Search results for query: *

  • Users: FinnK
  • Content: Threads
  • Order by date
  1. FinnK

    Two queries to one sql-string

    How do I rewrite these two queries to one sql string? q1: SELECT bID, b1, b2, b3, b4 FROM T1 WHERE b3=2; q2: SELECT T2.aID, T2.a1, T2.a2 FROM T2 LEFT JOIN T1 ON T2.aID = T1.b3 WHERE (((T1.b3) Is Null)); q3: SELECT ????? TIA Erik

Part and Inventory Search

Back
Top