MySQL Question

[Anon]

Hi,
I have a question about trying to sort of link together two tables by values. I have one table that has the following columns: id,text and then another table that has the colomns: id,table_a_id,user
I need to be able to search through the tables to display the rows in table one that the user is found to have linked to. Is this making sense? But I thought that there was some kind of command that I would be able to link the two together such as to check them on each other but none of my attempts have seemed to work. Thanks for the help

[Anon]

So you mean something like this?

SELECT table_a.text FROM table_a, table_b WHERE table_b.user = "diego" AND table_a.id = table_b.table_a_id

?

Diego

[Anon]

Thanks