Hacker News new | past | comments | ask | show | jobs | submit login

If you have identical field names, you can do in sql:

  Select * from a join b using (a_id)
Don't do this in Oracle though, pain follows when you try to touch an a_id column.



You can also do this in PRQL:

    from a
    join b [a_id]
is the equivalent query.




Consider applying for YC's W25 batch! Applications are open till Nov 12.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: