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 vote163 views1 answer
Mitigation of sql injection
SQL
0 vote250 views2 answers
How to get max from each department in sql
SQL
0 vote243 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote182 views1 answer
Provera dupliranih konatakata
SQL
0 vote210 views1 answer
Mysql pv progres
SQL
0 vote202 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote214 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
11 votes281 views2 answers
Import mysql dump command line windows
SQL
3 votes222 views2 answers
Mysql config user password
SQL
0 vote216 views1 answer
Permission denied postgres \copy csv command line
SQL