The simplest solution would be a correlated sub select: select A.* from table_A A where A.id in ( select B.id from table_B B where B.tag = ‘chair’ ) Alternatively you could join the tables and filter the rows you want: select A.* from table_A A inner join table_B B on A.id = B.id where B.tag … Read more
What you do here is called a JOIN (although you do it implicitly because you select from multiple tables). This means, if you didn’t put any conditions in your WHERE clause, you had all combinations of those tables. Only with your condition you restrict your join to those rows where the drink id matches. But … Read more
You can’t. However, you CAN use a transaction and have both of them be contained within one transaction. START TRANSACTION; INSERT INTO table1 VALUES (‘1′,’2′,’3’); INSERT INTO table2 VALUES (‘bob’,’smith’); COMMIT; http://dev.mysql.com/doc/refman/5.1/en/commit.html
For joins, I strongly prefer query-syntax for all the details that are happily hidden (not the least of which are the transparent identifiers involved with the intermediate projections along the way that are apparent in the dot-syntax equivalent). However, you asked regarding Lambdas which I think you have everything you need – you just need … Read more