>>Is there a shorthand notation when performing a multi-table join and
What's the difference between a "multi-table join" and a "join"? >> one column is to be equaled in all tables? > > Is this you are looking for? > > SELECT t1.c7,t2.c6 > FROM t1,t2 > USING (c1,c2,c3) > WHERE t1.c4='2004-2-28' AND t2.c5='xyz' > > performs the same as > > SELECT t1.c7,t2.c6 > FROM t1,t2 > WHERE t1.c1=t2.c1 and t1.c2=t2.c2 and t1.c3=t2.c3 > and t1.c4='2004-2-28' AND t2.c5='xyz' > > CN > I think this should work, too: SELECT t1.c7,t2.c6 FROM t1,t2 WHERE (t1.c1, t1.c2, t1.c3, t1.c4, t2.c5)= (t2.c1, t2.c2, t2.c3, '2004-2-28', 'xyz') ~Berend Tober ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]