the problme is in the where clause. the condition on the right side of the
OR statemnet will always test true.. or .. i should say is potentially
testing true. which is giving you your cartisian product.
i suggest you use either a left join or an inner join (depending on wether
you want nulls) in
hi hope someone here can give me a hand with this:(sorry for the cross post)
I have a table called categories, the key bieng an int, with a field for the
category name.
Another table called adverts, an advert has a category feild which is a
foreign key which links to the category table.
I reali
2 matches
Mail list logo
