[RESOLVED] how to join 4 tables?

[fandhie]

I have these 4 tables as follow and I want to join them

Table 1 : tb_category (cat_id, cat_name)

Table 2 : tb_singer (cat_id, singer_id, singer_name)

Table 3 : tb_album (singer_id, album_id, album_name, album_release)

Table 4 : tb_lyric (singer_id, album_id, lyric_id, lyric_title, lyric_content)

I want to show the query based on the latest entry then the visitor can sort them by category, singer, album and lyric title.

can anybody help?

[zypher11]

SELECT c.cat_id, c.cat_name, s.cat_id, s.singer_id, s.singer_name, a.singer_id, a.album_id, a.album_name, a.album_release, l.singer_id, l.album_id, l.lyric_id, l.lyric_tytle, l.lyric_content FROM tb_category c INNER JOIN tb_singer s ON s.cat_id = c.cat_id INNER JOIN tb_album a ON s.singer_id = a.singer_id INNER JOIN tb_lyric l ON s.singer_id = l.singer_id ORDER BY put order by data here;

delete cols you arent going to be displaying from the select clause and if you want the data from tables to show up even if there is no data for that row on one of the other tables change them to LEFT OUTER JOINS

[fandhie]

thank u zypher11..
🙂