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 vote41 views1 answer
Sp in sql server
SQL
7 votes46 views4 answers
How to reset the identity column in sql server
SQL
0 vote51 views1 answer
Reindexing all tables sql server
SQL
0 vote70 views1 answer
Postgresql port 5432 not open
SQL
0 vote47 views1 answer
Sql period overlap
SQL
3 votes46 views2 answers
Mysql HAVING
SQL
0 vote46 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote49 views1 answer
How to get nth number in sql
SQL
4 votes47 views1 answer
List tables sqlite
SQL
0 vote69 views2 answers
Suse Linux restart MySQL
SQL