在mysql中形成一个子查询?

2022-01-23 00:00:00 subquery 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;

我对如何用以下问题形成子查询感到困惑.两个表之间唯一相关的两个字段是 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;

相关文章