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

-1 vote317 views1 answer
How to format tables in sqlplus
SQL
0 vote325 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote394 views1 answer
Add new column in sql with foreign key
SQL
1 vote353 views1 answer
Can not connect to mysql server
SQL
0 vote346 views1 answer
Learn sqlite dart
SQL
0 vote321 views1 answer
Count column of tables psql
SQL
0 vote372 views2 answers
Add new column after in sql
SQL
0 vote344 views1 answer
Ignore case in string sql
SQL
2 votes361 views3 answers
Sql interview query questions
SQL
14 votes368 views5 answers
Sql oracle limit
SQL