INSERT INTO Table from multiple tables

by

Try this query:

     INSERT INTO C (aID, bID) 
     SELECT A.ID, B.ID 
     FROM A, B 
     WHERE A.Name="Me"
     AND B.Class="Math";

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Rank function in MySQL
  4. MySQL select 10 random rows from 600K rows fast
  5. Get a list of dates between two dates
  6. Calculate a running total in MySQL
  7. Find nearest latitude/longitude with an SQL query
  8. Simulate lag function in MySQL
  9. Get record counts for all tables in MySQL database
  10. How do I check if a column is empty or null in MySQL?
  11. Use MySQL spatial extensions to select points inside circle
  12. Subqueries with EXISTS vs IN – MySQL
  13. What is this operator in MySQL?
  14. MySQL create stored procedure syntax with delimiter
  15. 60 million entries, select entries from a certain month. How to optimize database?
  16. Is it possible to GROUP BY multiple columns using MySQL?
  17. MySQL monthly Sale of last 12 months including months with no Sale
  18. How to find non-existing data from another Table by JOIN?
  19. MySQL/SQL: Update with correlated subquery from the updated table itself
  20. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  21. Calculating a Moving Average MySQL?
  22. Strings as Primary Keys in MYSQL Database [closed]
  23. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  24. Select data from “show tables” MySQL query
  25. What is dynamic SQL?
  26. MySql. How to use Self Join
  27. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  28. How to select non “unique” rows
  29. Deleting a row based on the max value
  30. MySQL Multiple Joins in one query?

Leave a Comment