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 vote209 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote206 views1 answer
How to reset table in sql server
SQL
5 votes215 views1 answer
Oracle nls session
SQL
1 vote221 views3 answers
Sql procedure
SQL
0 vote220 views1 answer
Get statis values sql
SQL
0 vote211 views1 answer
Sql query to return field name of a table
SQL
2 votes216 views1 answer
Guid to string sql
SQL
-1 vote220 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote217 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote216 views1 answer
Tsql find procedure with name
SQL