the from statements usually does help eh! and of course naming the db tables correctly
<cfquery name="qCards" datasource="#dsn#" username="#un#" password="#pw#">
SELECT *
FROM userscards, tblcards
WHERE userscards.usersID = '#qgetUser.userID#'
AND userscards.cardID = tblcards.CardID
</cfquery>
thanks guys
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
