M
m.a
Hello,
I want to do a left join on a table and a select statement such as follow:
SELECT tbl1.*, q1.*
FROM tbl1 LEFT JOIN (SELECT tbl2.* FROM tbl2 WHERE (((tbl2.key2)=9)) as
q1 ON tbl1.key1 = q1.key1
WHERE (((tbl1.key1)=20));
Can I do this in Access database? If yes how? I know that I can create a
query for the inner select and use it, but since I am generating the select
string automatically in C#, I don't want to relay on another query on the
system.
Any help is very appreciated.
Regards
I want to do a left join on a table and a select statement such as follow:
SELECT tbl1.*, q1.*
FROM tbl1 LEFT JOIN (SELECT tbl2.* FROM tbl2 WHERE (((tbl2.key2)=9)) as
q1 ON tbl1.key1 = q1.key1
WHERE (((tbl1.key1)=20));
Can I do this in Access database? If yes how? I know that I can create a
query for the inner select and use it, but since I am generating the select
string automatically in C#, I don't want to relay on another query on the
system.
Any help is very appreciated.
Regards