On 05/10/05 06:17 PM CDT, Peter Fein <pfein@xxxxxxxxx> said: > Hiya- > > I need to do something like this: > > SELECT t1.symbol AS app_name, t2.outside_key AS app_id > FROM t2 LEFT JOIN t1 ON t1.t2_id=t2.id AS my_join > LEFT JOIN rows of arbitrary (app_name, app_id) ON > my_join.app_name=rows.app_name AND my_join.app_id=rows.app_id > The other thought was: SELECT t1.symbol AS app_name, t2.outside_key AS app_id FROM t2 LEFT JOIN t1 ON t1.t2_id=t2.id AS my_join UNION SELECT rows of arbitrary (app_name, app_id) Thanks! -- Peter Fein pfein@xxxxxxxxx 773-575-0694 Basically, if you're not a utopianist, you're a schmuck. -J. Feldman ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
