Pl sql join 3 tables

SELECT A.order_number, A.header_id, B.line_id, B.quantity, C.hold_price_id, C.released_flag
FROM Table_A a,
     Table_B b,
     Table_C c
WHERE a.header_id = b.header_id
AND   c.line_id = b.line_id
AND   a.header_id = c.header_id
AND   a.order_number = '123';

Source: stackoverflow.com

Similar codes

0 vote295 views1 answer
How to set up an anonymous function to variable in swift
SQL
10 votes286 views2 answers
SQL rounding numbers
SQL
-1 vote239 views1 answer
Mysql if example
SQL
0 vote290 views1 answer
Selecting Multiple Columns in SQL
SQL
2 votes273 views1 answer
Grant revoke privileges to mysql username
SQL
3 votes302 views5 answers
Sql select
SQL
2 votes303 views1 answer
Install postgresql centos 5
SQL
2 votes273 views1 answer
Add default sql server
SQL
0 vote275 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote252 views1 answer
Sql cross apply vs join
SQL