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 votes135 views1 answer
Index using in query plsql
SQL
0 vote141 views1 answer
Oracle last connection
SQL
0 vote132 views1 answer
Sql beginning of previous month
SQL
3 votes172 views1 answer
Apex set debug level
SQL
2 votes155 views1 answer
Mysql select default if null
SQL
0 vote163 views1 answer
Merge clause with inner join
SQL
2 votes153 views2 answers
Sqlalchemy return id after insert
SQL
0 vote141 views1 answer
Sql join on a subquery
SQL
0 vote154 views1 answer
Get date ISO in psql
SQL
0 vote142 views1 answer
Limit and offset in stored procedure mssql
SQL