Expert SQL help needed

dreamweaver, Expert SQL help needed Hi - using ASP/Access/Vbscript

Working on a "profile of the week" functions for my dating site.
Have a db table called profiles, where profile ID = url ID. This displays all
profiles based on url id.
Have a second db table called profileofweek that stores users applications for
becoming profile of the week.
It has a profileID coloumn, similar to the one in the profile table, and also
a Yes/No coloumn. If Yes (administrated by admin), then he/she is the profile
of the week.

How can I mix these two tables so that the ProfileID in the second table, with
YES, gets the corresponding profileID and all member details from the profiles
table?

Please help.

Bjorn.

dreamweaver >> Expert SQL help needed You could use a QUERY to join the tables together using the common column for
each table as a join link.

You would need to add in a Relationship first if using the QUERY Wizard.

Once you have joined the two tables and named the query, then in your
recordset you can select the Query from the VIEW list, and have all columns
from both tables available to you.

You can set a Filter to only show where your Yes/No column is Yes, in the
Query, just change to Design view and add in Yes to the Criteria field under
the Yes/No column.

Originally posted by: btn
Hi - using ASP/Access/Vbscript

Working on a "profile of the week" functions for my dating site.
Have a db table called profiles, where profile ID = url ID. This displays all
profiles based on url id.
Have a second db table called profileofweek that stores users applications for
becoming profile of the week.
It has a profileID coloumn, similar to the one in the profile table, and also
a Yes/No coloumn. If Yes (administrated by admin), then he/she is the profile
of the week.

How can I mix these two tables so that the ProfileID in the second table, with
YES, gets the corresponding profileID and all member details from the profiles
table?

Please help.

Bjorn.