Two queries to one sql-string 1

[FinnK]

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

 

[PHV]

What do you want to do ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[FinnK]

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

 

[Golom]

I don't see a reference to "Q1" in Q2.

Is it being called "T1" or "T2"?

 

[FinnK]

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));

 

[Golom]

SELECT T2.aID, T2.a1, T2.a2
FROM T2 LEFT JOIN 

(
SELECT b3 FROM T1 WHERE b3=2
) As X 

ON T2.aID = X.b3

WHERE X.b3 Is Null

 

[FinnK]

Hi Golom

Just as I needed.
Thanks very much.

/FinnK