在MySQL内部形成一个子查询? [英] forming a subquery inside mysql?

问题描述

列出与客户编号282具有相同代表编号的客户编号，客户名称和销售代表.这将是一个子查询，并且无需明确测试销售代表35.让MySQL为您完成工作.在此处插入查询和结果.

List the customer number, customer name, and sales rep that have the same rep number as customer number 282. This will need to be a subquery and do not test for sales rep 35 explicitly. Let MySQL do the work for you. Insert your query and results here.

  use premier_products;

  select customer.customer_num,customer.customer_name,rep.first_name
  (SELECT rep_num
   from rep,customer
   where rep.rep_num = customer.rep_num
   and customer_num = 282)
    from customer,rep;

im与如何形成带有以下问题的子查询相混淆.这两个表之间唯一相关的两个文件是rep.rep_num = customer.rep_num.

im confused with how to form a subquery with the following question. the only two fileds that are related between the two tables is rep.rep_num = customer.rep_num.

并且REP.FIRST_NAME代表销售代表...

AND REP.FIRST_NAME REFERS TO SALES REP...

推荐答案

您需要研究表在MySql中加入.

您的查询不需要子查询:

Your query doesn't need a subquery:

SELECT customer.customer_num, customer.customer_name, rep.first_name, rep.rep_num
FROM rep
JOIN customer
ON rep.rep_num = customer.rep_num
WHERE customer_num = 282;

这篇关于在MySQL内部形成一个子查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！