Question
inner join select
can someone help me with this query, i am getting errors, i
am not sure how to add a select function to the on clause.
could someone please advise what i am doing wrong
<CFQUERY datasource="#application.ds#" Name="GetSchH2">
SELECT *
FROM SMS_Players_Table
INNER JOIN appoint_table
ON ServerSMS <= #CreateODBCDateTime(Now())# OR ServerSMS <> ''
INNER JOIN SMS_Clubs_Table
ON appoint_table.LoginID = SMS_Clubs_Table.ClubID AND Country = 'Australia'
INNER JOIN (SELECT SUM(Cost)as TotalCost FROM SMS_Records) ON SMS_Records.ClubID = SMS_Clubs_Table.ClubID
WHERE appoint_table.App_ClientID = SMS_Players_Table.PlayerID AND appoint_table.HCODE = 'H2'
</cfquery>
could someone please advise what i am doing wrong
<CFQUERY datasource="#application.ds#" Name="GetSchH2">
SELECT *
FROM SMS_Players_Table
INNER JOIN appoint_table
ON ServerSMS <= #CreateODBCDateTime(Now())# OR ServerSMS <> ''
INNER JOIN SMS_Clubs_Table
ON appoint_table.LoginID = SMS_Clubs_Table.ClubID AND Country = 'Australia'
INNER JOIN (SELECT SUM(Cost)as TotalCost FROM SMS_Records) ON SMS_Records.ClubID = SMS_Clubs_Table.ClubID
WHERE appoint_table.App_ClientID = SMS_Players_Table.PlayerID AND appoint_table.HCODE = 'H2'
</cfquery>
AdChoices