Article at Practical SQL: Three Ways to JOIN
Our tables tend to have unique column names (old school!) so I wasn't aware of the disappearing columns when using USING. Thanks for that.
You can cut down on the typing a little by using correlation names instead of the full table names:
select * from ORDERS H join ORDERLINES D
on H.ORDERNO = D.ORDERNO
where H.ORDERNO = 123456
Our tables tend to have unique column names (old school!) so I wasn't aware of the disappearing columns when using USING. Thanks for that.
You can cut down on the typing a little by using correlation names instead of the full table names:
select * from ORDERS H join ORDERLINES D
on H.ORDERNO = D.ORDERNO
where H.ORDERNO = 123456
Comment