need to form SQL join/subQuery on multiple tables

There are 3 tables –

tables — columns

ABC – abc_id, abc_name, active_flag

XYZ – xyz_id, xyz_name, active_flag

ABC_XYZ – abc_xyz_id, abc_id, xyz_id, active_flag

id column in each table is PK I need to form a query which will return output like – for each abc_name there will be multiple xyz_names

like below –

abc_name1 –

    xyz_name1
    xyz_name2
    xyz_name3
    xyz_name4

abc_name2 –

    xyz_name5
    xyz_name6
    xyz_name2
    xyz_name4

I am using sybase DB in my project

any help will be appreciated

Answer

To join all 3 your tables, you can start fro the table ABC_XYZ as shown below-

You can get some more details HERE about SQL JOIN

SELECT * 
-- SELEC * will return all records from all tables
-- You can also select specific column from different table usinf table Alias and column name
FROM ABC_XYZ A
INNER JOIN ABC B ON A.abc_id = B.abc_id 
INNER JOIN XYZ C ON A.xyz_id = C.xyz_id