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 votes323 views1 answer
Two selects in one query
SQL
0 vote365 views1 answer
How to inner join 4 tables in sql
SQL
0 vote321 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote310 views2 answers
Mysql multiply
SQL
0 vote354 views1 answer
Reindex mssql table
SQL
0 vote347 views1 answer
Oracle sql alter view add column
SQL
0 vote315 views1 answer
Compare if is null sql
SQL
0 vote323 views1 answer
Oracle sql drop table
SQL
0 vote330 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes318 views2 answers
Useradd postgres
SQL