> >What am I missing? I think it's pulling all adverts from advert_details
> >which match an email address in payments or invoices.
>
> You'll need to add 1 more join since you are using 3 tables in your
> From clause. You have payments joined to advert_details. Now you need
> to join invoices to payments will probably do the trick.
Ah, what a dufus I am. Seems to be working very well now - and has, I hope,
inadvertently given me an idea as to my next Query problem.
Thanks to all.
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
