ScoobyWon't

I'm attempting to filter my recordset in coldfusion to on display records which include Litter.Littername=A

It's ok if I'm only working with one table, it happily filters. But when I start joining tables it goes a bit funny and won't allow me to use the where clause. It's working fine within Access (sorry but I don't own a real SQL Server )

SELECT Litter.Littername, Litter.LitterID, Dogs.Kcname, Dogs.DogID, Dogs.Littername
FROM Dogs INNER JOIN Litter ON Dogs.Littername=Litter.Littername
WHERE Litter.Littername='#URL.Littername#'
ORDER BY Dogs.Kcname

Any ideas?

Jza

Just a quickie - try dogs. rather than litter. for the URL bit?

J

RichB

Should there not be the name of the table before the name you give it i.e litter or dogs.

SELECT Litter.Littername, Litter.LitterID, Dogs.Kcname, Dogs.DogID, Dogs.Littername
FROM dogs_table Dogs INNER JOIN litter_table Litter ON Dogs.Littername=Litter.Littername
WHERE Litter.Littername='#URL.Littername#'
ORDER BY Dogs.Kcname

I'm no expert but that's how I've done it before...

ScoobyWon't

Hi guys,

Got it working shortly after posting. It works fine as:

SELECT Litter.Littername, Litter.LitterID, Dogs.Kcname, Dogs.DogID, Dogs.Littername
FROM Dogs INNER JOIN Litter ON Dogs.Littername=Litter.Littername
WHERE Litter.Littername='#URL.Littername#'
ORDER BY Dogs.Kcname

Thanks for looking