Re: Cartesian Joins

As Daniel said, your are missing some where conditions. Presuming the primary key for PCAT table is ID, you might need something like "and PCAT.ID = PCATLINK.ID" This is just a guess, as I don't know what business logic you are trying to achieve.
note that when you list a table multiple times in the from clause, the multiple occurence are treated as different tables. Received on Tue Dec 07 2004 - 12:12:21 CST