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

3 votes107 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote118 views1 answer
Delete specific row in sql
SQL
0 vote100 views1 answer
Oracle activate program
SQL
5 votes110 views3 answers
Truncate function in sql oracle
SQL
0 vote141 views1 answer
Sqlite display headers on columns
SQL
1 vote98 views1 answer
Store select query result in variable sql server
SQL
0 vote95 views1 answer
Oracle free up space in tablespace
SQL
0 vote104 views1 answer
Oracle enable chain
SQL
14 votes107 views6 answers
Auto_increment mysql
SQL
0 vote106 views1 answer
Closure in sql
SQL