Knowledge Base Contributions

Below is a list of the knowledge base entries that Richard Mitchell has contributed to:

• Imagine 2 tables:t1(id int autoinc)(data:1,2,3...),t2(id int)(1,2,2,1,1...) Need query to get t1.id & count(t2.id)where t1.id=t2.id. t2.id CAN BE NUL!
  

• How can i List all the Records that begin with 'D'?
  

• What is the syntax to an insert query with a select query inside ?