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 Westi 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
  • Order by date
  1. FinnK

    Two queries to one sql-string

    Hi Golom Just as I needed. Thanks very much. /FinnK
  2. FinnK

    Two queries to one sql-string

    Sorry. I made a mistake. This is the correct q2. q1: SELECT bID, b1, b2, b3, b4 FROM T1 WHERE b3=2; q2: SELECT T2.aID, T2.a1, T2.a2 FROM T2 LEFT JOIN q1 ON T2.aID = q1.b3 WHERE (((T1.b3) Is Null));
  3. FinnK

    Two queries to one sql-string

    Hi When I run q2 - that uses q1 - it gives me a recordset. But I need to have only one query that gives me the same recordset. /Erik
  4. 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