lookup two tables in a database

[loganswell]

Hi,

Does anyone have any sample code for the following scenario?

Database has two tables. One table is searched until a value of a record / field is true. The ID if THAT record is then used to look up the second table to see if the ID exists in there and if so display its contents. This would have iteration until EOF on the first table.

Thank you!

Jim

 

[alsoknownas]

I don't very little sql to help you with joins, but I can suggest is creating either a query in access or a view in sql displaying all the relevant info and just pull from it

--------------------------------------------------------------------------------
​

 

[alsoknownas]

meant to say, I know very little sql. (and little spelling also)

--------------------------------------------------------------------------------
​

 

[GaryC123]

"SELECT * FROM table1 INNER JOIN table2 ON table1.ID = table2.ID WHERE table1.ID= 123"

http://www.intouchmedialtd.com

 

[loganswell]

That's great - just off to try it out! Thanks )