Hello! Help with the request. There are 2 tables

1. User list

user_id name

2. List of goods

 id user_1 (user_id тот кто продает) user_2 (user_id тот кто покупает)

I need to select rows from table 2 with names (name) according to user_id. Help me to understand!

  • Selection of two tables in MySQL. JOIN operator. - Palmervan
  • Use 2 LEFT JOIN - fremail
  • one
    such babble should know, shame not to know. - IntegralAL
  • @IntegralAL is ashamed to point out flaws on a so-like site. - etki
  • @Etki, believe me, too, who criticizes what, this is normal. I do not complain about the fact that sometimes they accuse me of not knowing something or not knowing how. Criticism simply stimulates sometimes for more progress, and sometimes breaks. - IntegralAL

0