Suggest an editImprove this articleRefine the answer for “What does USING do in a JOIN?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`USING` in a `JOIN` is a shorthand for the join condition when **the columns in both tables share the same name**, e.g. `JOIN customers USING (customer_id)` instead of `JOIN customers ON orders.customer_id = customers.customer_id`. **Key point:** the difference is that with `USING`, the result has **only one** `customer_id` column, not two (one per table).Shown above the full answer for quick recall.Answer (EN)Image`USING` in a `JOIN` is a shorthand for the join condition, used when **the columns in both tables share the same name**. ### Example ```sql SELECT * FROM orders JOIN customers USING (customer_id); ``` This is the same as: ```sql SELECT * FROM orders JOIN customers ON orders.customer_id = customers.customer_id; ``` The difference: with `USING`, the result has **only one** `customer_id` column, not two (one from each table).For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.