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

4 votes456 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote345 views1 answer
Oracle create program if no exists
SQL
0 vote370 views1 answer
Run mysql xampp shell
SQL
0 vote421 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote408 views1 answer
Check constraint is violated
SQL
0 vote339 views1 answer
Grant access on table in oracle
SQL
28 votes375 views6 answers
Mysql change user password
SQL
2 votes368 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote352 views1 answer
SqlFunction does not exist
SQL
5 votes338 views2 answers
Mysql where in array
SQL