select a.* from TABLE1 a left join TABLE2 b on b."Val" = :Val and b."Pos" = :Pos and a."ID" =
b."ID_ref";

Alternatively, you can create a named view for your sub-query and do a join against that view. But
as you have parameters in the query definition, this seems inappropriate.

-Philip

---------- Original Message -----------
From: "Gediminas" <gugini@...>
To: firebird-support@yahoogroups.com
Sent: Mon, 07 Mar 2005 20:44:58 -0000
Subject: [firebird-support] left join

> have tried to make such query:
>
> select * from TABLE1 a
> left join ( select * from TABLE2 a2 where a2."Val" = :Val and a2."Pos"
> = :Pos ) b
> on a."ID" = b."ID_ref"
>
> it seems, that FB1.5 don't support such subqueries (memory tables),
> how to rewrite query to get working FB1.5 query?
>
> Yahoo! Groups Links
>
>
>

------- End of Original Message -------