Re: newbie: select from a table, conditioned on the entry in another table

Christoph Lehmann wrote: Hi I have 2 tables, say A and B. One field in table A, say A_link, points to a field B_link in table B. I need to select entries in A, which fulfill two conditions: A_cond1 = XX and B_cond2 = YY. E.g table Atable B A_cond1 A_linkB_link B_cond

newbie: select from a table, conditioned on the entry in another table

Hi I have 2 tables, say A and B. One field in table A, say A_link, points to a field B_link in table B. I need to select entries in A, which fulfill two conditions: A_cond1 = XX and B_cond2 = YY. E.g tabel A table B A_cond1 A_link B_link B_cond2 1