Not sure if this is what you are asking, but how about: SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c2
Big Brother tells me that David Perron wrote: > > Is there a way to do this? Im trying to LEFT JOIN to a table that needs to > select based on 2 keys, but the query Im writing only has the keys > individually in two separate tables, [...] -- "What we observe is not nature itself, but nature Jack McKinney exposed to our method of questioning. http://www.lorentz.com -Werner Karl Heisenberg [EMAIL PROTECTED] 1024D/D6056304 4096g/1D649CB4 2004 Chicago Cubs magic number: 163
pgp00000.pgp
Description: PGP signature