Hey gang...
First attempt at doing a view in SQL7, and I've got a semi-odd need.
I have two tables - joined by an ID. Table one has a single record, table
two has multiple records tied to the first table's single record. I want to
get my view set up so it pulls the common ID, and ONLY the first of multiple
records in the second table.
The code the view designer generates is:
SELECT N.NewsletterID, NC.NewsletterTitle
FROM TNewsletter N INNER JOIN
TNewsletterContent NC ON N.NewsletterID = NC.NewsletterID
Right now I've got two records in "TNewsletter", and four in
"TNewsletterContent" - two for each of the two records in the first table.
The code above returns four records - I want to get it to return just two.
Thoughts?
Thanks in advance -
--Scott
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
