i have two tables A and B
Table A
Table B
I want to get all songs data which is matched to genre_id=1 from Table A, is there any query for that
CodePudding user response：
select name
from A
inner join B on A.song_id=B.song_id
where B.genre_id=1
i have two tables A and B
Table A
Table B
I want to get all songs data which is matched to genre_id=1 from Table A, is there any query for that
CodePudding user response：
select name
from A
inner join B on A.song_id=B.song_id
where B.genre_id=1