Hello Me, Yes I found a solution for myself. So for any others that have this
problem, simply add a "Group By"
So now:
SELECT TOP 1 Tbl1.Name
>From (((T2 INNER JOIN T3 ON T2.AID = T3.AID)
INNER JOIN T4 ON T3.T4ID = T4.T4ID)
INNER JOIN Tbl1 ON T4.PgID = Tbl1.PgID)
WHERE (T2.photoID = #GetResults.photoID#)
GROUP BY T2.T2ID, Tbl1.Name
ORDER BY T2.T2ID
Any idea why this is? Didn't really seem like an obvious solution to me, but
there you go.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3218
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
