Kathleen Anderson 13 December 2008 00:55:34 [ permanent link ]
You should be able to do it the same way you do with one table. The only thing that won't work is Lookup fields. To get a jump start, write your query in Access and copy and paste the SQL into the DRW.
Thanks Kathleen, I managed to do that with your help..
My next step is that I have a page with multiple choices:
Team 1 Team 2 etc.
and when I select say Team 1 I go to a summary page which I want to show only data associated with team 1, but using a custom SQL I keep getting all Teams..
I have been very succesful doing this with a single table as the DRW helps greatly, but need help to do it with joining tables using a custom sql code.
John P.
"Kathleen Anderson" <kanderson@remove.mvps.org> wrote in message news:eGVheRKXJHA.4960@TK2MSFTNGP02.phx.gbl...
You should be able to do it the same way you do with one table. The only
thing that won't work is Lookup fields. To get a jump start, write your
query in Access and copy and paste the SQL into the DRW.
Jens Peter Karlsen 16 December 2008 06:05:16 [ permanent link ]
Of course you get them all. Your WHERE clause would only exclude teams that doesn't have a sponsor. You should use the specifik ID of the team you want results from not all IDs as you do below. Something like: SELECT teams.ID, teams.*, sponsors.* FROM teams INNER JOIN sponsors ON teams.ID = sponsors.teamid WHERE sponsors.teamid="team1"
Regards Jens Peter Karlsen.
On Mon, 15 Dec 2008 12:46:49 -0500, "John P." <parkejo@gmail.com> wrote:
Thanks again Kathleen, I am sure I am getting close but still no luck.
Stefan B Rusynko 16 December 2008 12:20:56 [ permanent link ]
The OP is using link parameters from index.asp So in the top of the team.asp page he needs <% TeamID=Request.QueryString("ID") 'add check to send them back if no team id in query string IF Len(TeamID)=0 Then Response.Redirect "index.asp" %>
Then the SQL would be SQL="SELECT teams.ID, teams.*, sponsors.* FROM teams INNER JOIN sponsors ON teams.ID = sponsors.teamid WHERE sponsors.teamid=" & TeamID
_____________________________________________ SBR @ ENJOY [ Microsoft MVP - FrontPage ] "Warning - Using the F1 Key will not break anything!" (-; _____________________________________________
"Jens Peter Karlsen" <jpkarlsen@mvps.org> wrote in message news:366ek4dgflhpd3lt3s400dtt70qu4cpgrf@4ax.com... | Of course you get them all. Your WHERE clause would only exclude teams | that doesn't have a sponsor. | You should use the specifik ID of the team you want results from not | all IDs as you do below. Something like: | SELECT teams.ID, teams.*, sponsors.* | FROM teams INNER JOIN sponsors ON teams.ID = sponsors.teamid | WHERE sponsors.teamid="team1" | | Regards Jens Peter Karlsen. | | On Mon, 15 Dec 2008 12:46:49 -0500, "John P." <parkejo@gmail.com> | wrote: | | >Thanks again Kathleen, I am sure I am getting close but still no luck. | > | >The statement I have (which verifies okay) is | > | >SELECT teams.ID, teams.*, sponsors.* | >FROM teams INNER JOIN sponsors ON teams.ID = sponsors.teamid | >WHERE sponsors.teamid=teams.ID | > | >But I still get all the teams.. | >
Mike Mueller 18 December 2008 04:12:29 [ permanent link ]
What I would do is take MOST of your sql statement "SELECT teams.ID, teams.*, sponsors.* FROM teams INNER JOIN sponsors ON teams.ID = sponsors.teamid" and create a View in sql (or query in Access) and I'll call it vTeamsToSponsors.
Then; in your web page coding, I would use this SQL statement "SELECT * FROM vTeamsToSponsors WHERE sponsors.teamid=::ID::"
WHERE sponsors.teamid=::ID::"
"John P." <parkejo@gmail.com> wrote in message news:%23JsUoTIYJHA.5336@TK2MSFTNGP02.phx.gbl...
Thanks everyone, I am really getting close now. I have it reurning only
for the applicable team but is shows a complete view for each sponsor I am
just trying to show 1 view with all the sponsors available.
But again I really appreciate your help as I have climed over a couple of
barriers.
Thanks
John P.
The statement I have in place is:
SELECT teams.ID, teams.*, sponsors.* FROM teams INNER JOIN sponsors ON
teams.ID = sponsors.teamid WHERE sponsors.teamid=::ID::
"Mike Mueller" <me@my.domain.com> wrote in message
news:OlglNc$XJHA.3808@TK2MSFTNGP05.phx.gbl...
There would be a performance gain by turning this sql statement into a
view
"Stefan B Rusynko" <sbr_enjoy@hotmail.com> wrote in message
news:ueWVb%231XJHA.5108@TK2MSFTNGP05.phx.gbl...
The OP is using link parameters from index.asp
So in the top of the team.asp page he needs
<%
TeamID=Request.QueryString("ID")
'add check to send them back if no team id in query string
IF Len(TeamID)=0 Then Response.Redirect "index.asp"
%>
Then the SQL would be
SQL="SELECT teams.ID, teams.*, sponsors.* FROM teams INNER JOIN sponsors
ON teams.ID = sponsors.teamid WHERE sponsors.teamid=" &
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
