Simple sql statement problem

Hi,

I'm new to this forum and am hoping that someone can help.

My app is an asp application running on an ms access database.

I have two tables , customers and couplesInfo

I have a main page for displaying customer info. I have an if then statement that will display a link if the client has filled out the couples form. The two fields that have the same information are custID and cicustID. I need the main page to display info regardless if a client has filled out the couples form. For the link to display the couples info I need to get the ciID from the couples form that matches that particular client in the main page. The sql statement I'm having trouble with is this one. tkey is the id that is passed from the customer selection page. I have stripped down this statement in hopes that this will make it easier for someone to help.

strsql = "SELECT * FROM tblCustomers, tblCouplesInfo WHERE custID = " & tkey

I'm still learning sql and would appreciate any help. I have tried several different ways and none of them have worked.

You can do this all in one statement, using a join.Replace the id with whatever your primary key fields are. This will return all records for both tables that are joined by the key. If the couples table has not been completed, the results for the couples fields will be NULL.